Top "Sql-server-2008-r2" questions

Use this tag for questions specific to the 2008 R2 version of Microsoft's SQL Server.

UNION ALL in CTE

I'm trying to get a UNION ALL working with a CTE which I'm using for paging. I need to get …

sql sql-server-2008 sql-server-2008-r2 common-table-expression union-all
add CHECK constraint to already populated table

I created a table called test with column called code: create table test( code char(3) not null); I then populated …

sql sql-server-2008-r2 check-constraints
How do I get SQL server 2008r2 to show me the Errors?

I am running an Insert script that is supposed to insert 13,381 rows into a blank DB from SSMS. Its telling …

sql sql-server sql-server-2008 sql-server-2008-r2
Same number of columns for Union Operation

I was going through union and union all logic and trying examples. What has puzzled me is why is it …

sql sql-server-2008-r2 union union-all
Sort string as number in sql server

I have a column that contains data like this. dashes indicate multi copies of the same invoice and these have …

sql sorting sql-server-2008-r2 natural-sort
SSIS - OLE DB Destination - Table or Views load vs. Fast-load

From what I've read: Table or Views data access mode commits each row at a time as a transaction. Thus, …

ssis sql-server-2008-r2 data-warehouse
DateAdd Column caused an overflow

After executing the following query I am getting an error Adding a value to a 'datetime' column caused an overflow. …

sql sql-server sql-server-2008 sql-server-2008-r2 ssas
Alias names to with rollup in SQL queries?

I am using with rollup in my sql query. I am not getting alias name for rollup. My SQL is …

sql tsql stored-procedures sql-server-2008-r2 rollup
Can I create SSRS Reports in VS 2015 using SQL Server 2008 R2?

I'm new to SSRS. Recently upgraded my development environment from Visual Studio 2010 to Visual Studio 2015 Enterprise Edition. Currently my reports …

reporting-services visual-studio-2015 sql-server-2008-r2 ssrs-2008-r2
How to resolve SQL Server deadlocks - once changing order and shortening queries is exhausted?

i have two hypothetical queries: UPDATE BankAccounts SET HomePhone = '+1 252-555-0912' WHERE AccountNumber = 14400000619 and SELECT * FROM BankAccounts WHERE …

sql-server sql-server-2008-r2 database-deadlocks