|
Using DATEADD in Case statement (MS Server 2012)
|
|
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?
|
|
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
|
|
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
|
|
17
|
1905
|
March 9, 2016
|
|
Select records with CASE statement
|
|
11
|
1244
|
March 9, 2016
|
|
Inner joins
|
|
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
|