|
Selecting parent records and child but leaving fields blank
|
|
2
|
786
|
April 23, 2016
|
|
NOT EXISTS Using IN
|
|
5
|
967
|
April 23, 2016
|
|
SQL Coalesce or other Option?
|
|
2
|
737
|
April 23, 2016
|
|
Case with Substring return more than 1 value?
|
|
2
|
816
|
April 23, 2016
|
|
Multiple row value as Column value
|
|
4
|
971
|
April 23, 2016
|
|
Select with alternate value
|
|
5
|
938
|
April 22, 2016
|
|
Update table with values from another one (only for results that have been previously generated)
|
|
4
|
824
|
April 21, 2016
|
|
Update HH:MM:SS to Seconds
|
|
2
|
658
|
April 21, 2016
|
|
EXCLUDE field from GROUP BY when processing SUM
|
|
3
|
1070
|
April 21, 2016
|
|
MERGE INTO with SCD Type2 FROM Historical Table
|
|
1
|
799
|
April 21, 2016
|
|
Adding business hours to a datetime field
|
|
1
|
2205
|
April 21, 2016
|
|
Simple Update - Error?
|
|
3
|
501
|
April 21, 2016
|
|
Date collapse logic help needed
|
|
0
|
588
|
April 20, 2016
|
|
How to make this function faster
|
|
3
|
654
|
April 20, 2016
|
|
Creating an XML document within SQL - Attributes
|
|
9
|
1351
|
April 19, 2016
|
|
Night shift Hours calculation
|
|
14
|
9088
|
April 19, 2016
|
|
Performance tuning
|
|
4
|
1002
|
April 19, 2016
|
|
Too many rows returned in join statement
|
|
5
|
1039
|
April 19, 2016
|
|
Cluster behavior of Timeseries
|
|
3
|
783
|
April 19, 2016
|
|
Searching in PDF-files with Full Text Indexes
|
|
0
|
795
|
April 19, 2016
|
|
Read Txt file that is varchar and put in column of smallint
|
|
1
|
602
|
April 19, 2016
|
|
Separating column values
|
|
3
|
682
|
April 18, 2016
|
|
COUNT DISTINCT and GROUP BY question
|
|
5
|
1494
|
April 18, 2016
|
|
Managing TODO comments in SQL code
|
|
4
|
3350
|
April 18, 2016
|
|
Group results by item showing most recent date and extra info
|
|
2
|
888
|
April 17, 2016
|
|
Comparing doc or pdf Files from Using SQL Server
|
|
1
|
722
|
April 17, 2016
|
|
Improve query and extracting data from XML
|
|
1
|
699
|
April 17, 2016
|
|
Retain Previous ROW values -SQL
|
|
1
|
933
|
April 17, 2016
|
|
Compare 2 column dates
|
|
4
|
1146
|
April 16, 2016
|
|
Return records based on lookup in other tables
|
|
2
|
576
|
April 16, 2016
|