|
USING SUBSTRING AND CAST......Grrrrr!
|
|
5
|
1477
|
February 23, 2016
|
|
SQL join query with a where clause
|
|
12
|
1681
|
February 23, 2016
|
|
Insert variable number of rows, depending of a value in a row
|
|
1
|
590
|
February 23, 2016
|
|
Converting row data to columns with conditional data
|
|
10
|
1274
|
February 23, 2016
|
|
Master records with no transactional data
|
|
4
|
822
|
February 22, 2016
|
|
Logging Stored Procedure Calls
|
|
8
|
3699
|
February 22, 2016
|
|
Split string by SIZE on delimiter
|
|
4
|
835
|
February 22, 2016
|
|
Msg 102, Level 15, State 1, Server WCS\INHANCE, Line 1 Incorrect syntax near 'account_num'
|
|
5
|
1215
|
February 22, 2016
|
|
NULL Values
|
|
2
|
362
|
February 22, 2016
|
|
Update date column
|
|
7
|
1105
|
February 22, 2016
|
|
Invalid column name
|
|
5
|
1441
|
February 22, 2016
|
|
Try / Catch multiple errors
|
|
3
|
962
|
February 21, 2016
|
|
Calculating live policy counts (quite advanced!)
|
|
1
|
612
|
February 20, 2016
|
|
Displaying DateTime with 24-hour Time
|
|
5
|
955
|
February 20, 2016
|
|
How to join on partial string match
|
|
7
|
25190
|
February 20, 2016
|
|
Median
|
|
2
|
594
|
February 19, 2016
|
|
Deadlock question
|
|
13
|
2505
|
February 19, 2016
|
|
What Collation to Use?
|
|
2
|
575
|
February 19, 2016
|
|
T-sql 2012 select with different types of data
|
|
1
|
422
|
February 19, 2016
|
|
Distinct values from SQL
|
|
33
|
2950
|
February 18, 2016
|
|
Selection problem
|
|
3
|
500
|
February 18, 2016
|
|
Use an if or statement
|
|
7
|
573
|
February 18, 2016
|
|
Recursive query at subquery
|
|
0
|
309
|
February 17, 2016
|
|
Comparing column values
|
|
12
|
859
|
February 17, 2016
|
|
How to have a case block in query where condition
|
|
8
|
802
|
February 17, 2016
|
|
Updating one table from another table based on date range and id
|
|
2
|
604
|
February 17, 2016
|
|
Matching pairs of rows
|
|
15
|
1119
|
February 17, 2016
|
|
Querying denormalised tables
|
|
0
|
602
|
February 17, 2016
|
|
Error doesn't seem to be trapped when reading a temporary table after committed transaction
|
|
4
|
773
|
February 16, 2016
|
|
Summing unique values within a temp table
|
|
6
|
834
|
February 16, 2016
|