Transact-SQL

Topic	Replies	Views	Activity
UPDATE([column_name]) in an INSERT trigger	2	1037	March 17, 2016
ALTER TABLE failed because the following SET options have incorrect settings: 'QUOTED_IDENTIFIER'	2	7936	March 17, 2016
Adding new rows in table with multiple indexes	1	516	March 17, 2016
Getting a value based on upper and lower bound columns in table	3	4199	March 17, 2016
The MERGE statement attempted to UPDATE or DELETE the same row more than once	14	4935	March 17, 2016
Amending Table Structure Using Metadata Table	5	1139	March 16, 2016
Help With Summation Query	5	1137	March 16, 2016
Row Number Partition By	1	607	March 16, 2016
Sum, max & stuff	9	1877	March 15, 2016
Subtract the amount over?	3	608	March 15, 2016
Nested calls causing the error	7	1302	March 15, 2016
Need help to convert a cursor to a temp table code	0	664	March 15, 2016
T-sql 2012 sort order	5	1414	March 15, 2016
Selecting columns as rows	2	519	March 15, 2016
What to check if my database stored procedure running slow? sql2008	1	705	March 15, 2016
How to calculate percentage	3	783	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	568	March 11, 2016
Cannot access table created from query string	2	836	March 10, 2016
Remove blank columns from pivot	2	694	March 10, 2016
Basic addition of two columns	2	558	March 10, 2016
Delete 1 that has 2 of the same ids	5	819	March 10, 2016
Date Format	7	1047	March 10, 2016
Convert string to datetime OPENXML WITH	1	978	March 10, 2016
Convert /Error sql2005	17	1901	March 9, 2016
Select records with CASE statement	11	1241	March 9, 2016
Inner joins sql2012	8	1485	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	2612	March 9, 2016
Sequencenumber	1	379	March 9, 2016