Transact-SQL

Topic	Replies	Views	Activity
Using DATEADD in Case statement (MS Server 2012) sql2012	2	4249	March 17, 2016
UPDATE([column_name]) in an INSERT trigger	2	1040	March 17, 2016
ALTER TABLE failed because the following SET options have incorrect settings: 'QUOTED_IDENTIFIER'	2	7983	March 17, 2016
Adding new rows in table with multiple indexes	1	518	March 17, 2016
Getting a value based on upper and lower bound columns in table	3	4210	March 17, 2016
The MERGE statement attempted to UPDATE or DELETE the same row more than once	14	4948	March 17, 2016
Amending Table Structure Using Metadata Table	5	1154	March 16, 2016
Help With Summation Query	5	1141	March 16, 2016
Row Number Partition By	1	610	March 16, 2016
Sum, max & stuff	9	1880	March 15, 2016
Subtract the amount over?	3	609	March 15, 2016
Nested calls causing the error	7	1304	March 15, 2016
Need help to convert a cursor to a temp table code	0	665	March 15, 2016
T-sql 2012 sort order	5	1418	March 15, 2016
Selecting columns as rows	2	521	March 15, 2016
What to check if my database stored procedure running slow? sql2008	1	708	March 15, 2016
How to calculate percentage	3	785	March 12, 2016
Parent and child relationship is broken when do the sort based on parent name sql2008	1	697	March 11, 2016
Run generated script via jdbc	1	553	March 11, 2016
Joining 2 grouped queries	2	572	March 11, 2016
Cannot access table created from query string	2	838	March 10, 2016
Remove blank columns from pivot	2	697	March 10, 2016
Basic addition of two columns	2	559	March 10, 2016
Delete 1 that has 2 of the same ids	5	819	March 10, 2016
Date Format	7	1052	March 10, 2016
Convert string to datetime OPENXML WITH	1	979	March 10, 2016
Convert /Error sql2005	17	1905	March 9, 2016
Select records with CASE statement	11	1244	March 9, 2016
Inner joins sql2012	8	1489	March 9, 2016
Msg 8120, Level 16, State 1, Line 1 Column 'Advisors.FirstName' is invalid in the select list because it is not contained in either an aggregate function or the GROUP BY clause	3	2635	March 9, 2016