Use this tag for questions specific to the 2008 R2 version of Microsoft's SQL Server.
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-allI 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-constraintsI 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-r2I 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-allI 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-sortFrom 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-warehouseAfter 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 ssasI 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 rollupI'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-r2i 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