|
NOT EXISTS Using IN
|
|
5
|
958
|
April 23, 2016
|
|
SQL Coalesce or other Option?
|
|
2
|
737
|
April 23, 2016
|
|
Case with Substring return more than 1 value?
|
|
2
|
811
|
April 23, 2016
|
|
Multiple row value as Column value
|
|
4
|
970
|
April 23, 2016
|
|
Select with alternate value
|
|
5
|
937
|
April 22, 2016
|
|
Update table with values from another one (only for results that have been previously generated)
|
|
4
|
822
|
April 21, 2016
|
|
Update HH:MM:SS to Seconds
|
|
2
|
657
|
April 21, 2016
|
|
EXCLUDE field from GROUP BY when processing SUM
|
|
3
|
1035
|
April 21, 2016
|
|
MERGE INTO with SCD Type2 FROM Historical Table
|
|
1
|
793
|
April 21, 2016
|
|
Adding business hours to a datetime field
|
|
1
|
2198
|
April 21, 2016
|
|
Simple Update - Error?
|
|
3
|
498
|
April 21, 2016
|
|
Date collapse logic help needed
|
|
0
|
586
|
April 20, 2016
|
|
How to make this function faster
|
|
3
|
648
|
April 20, 2016
|
|
Creating an XML document within SQL - Attributes
|
|
9
|
1344
|
April 19, 2016
|
|
Night shift Hours calculation
|
|
14
|
9050
|
April 19, 2016
|
|
Performance tuning
|
|
4
|
1000
|
April 19, 2016
|
|
Too many rows returned in join statement
|
|
5
|
1011
|
April 19, 2016
|
|
Cluster behavior of Timeseries
|
|
3
|
779
|
April 19, 2016
|
|
Searching in PDF-files with Full Text Indexes
|
|
0
|
793
|
April 19, 2016
|
|
Read Txt file that is varchar and put in column of smallint
|
|
1
|
599
|
April 19, 2016
|
|
Separating column values
|
|
3
|
682
|
April 18, 2016
|
|
COUNT DISTINCT and GROUP BY question
|
|
5
|
1489
|
April 18, 2016
|
|
Managing TODO comments in SQL code
|
|
4
|
3338
|
April 18, 2016
|
|
Group results by item showing most recent date and extra info
|
|
2
|
886
|
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
|
928
|
April 17, 2016
|
|
Compare 2 column dates
|
|
4
|
1141
|
April 16, 2016
|
|
Return records based on lookup in other tables
|
|
2
|
572
|
April 16, 2016
|
|
I Need Query To Display Employee Attendence
|
|
0
|
498
|
April 15, 2016
|