|
Embedding SELECT statement into WHERE clause
|
|
4
|
958
|
April 26, 2016
|
|
Query throws error when adding a WHERE condition
|
|
4
|
1091
|
April 26, 2016
|
|
SELECT Statement with AND Operator Confusion
|
|
4
|
725
|
April 26, 2016
|
|
Calculating downtime
|
|
9
|
1662
|
April 26, 2016
|
|
Xml encoding
|
|
0
|
636
|
April 26, 2016
|
|
Query: Find Duplicates not identically
|
|
0
|
500
|
April 26, 2016
|
|
Bradford Factor calculation
|
|
2
|
1068
|
April 24, 2016
|
|
CTE - create range values
|
|
1
|
666
|
April 23, 2016
|
|
Selecting parent records and child but leaving fields blank
|
|
2
|
802
|
April 23, 2016
|
|
NOT EXISTS Using IN
|
|
5
|
1002
|
April 23, 2016
|
|
SQL Coalesce or other Option?
|
|
2
|
738
|
April 23, 2016
|
|
Case with Substring return more than 1 value?
|
|
2
|
835
|
April 23, 2016
|
|
Multiple row value as Column value
|
|
4
|
972
|
April 23, 2016
|
|
Select with alternate value
|
|
5
|
952
|
April 22, 2016
|
|
Update table with values from another one (only for results that have been previously generated)
|
|
4
|
829
|
April 21, 2016
|
|
Update HH:MM:SS to Seconds
|
|
2
|
661
|
April 21, 2016
|
|
EXCLUDE field from GROUP BY when processing SUM
|
|
3
|
1170
|
April 21, 2016
|
|
MERGE INTO with SCD Type2 FROM Historical Table
|
|
1
|
823
|
April 21, 2016
|
|
Adding business hours to a datetime field
|
|
1
|
2216
|
April 21, 2016
|
|
Simple Update - Error?
|
|
3
|
515
|
April 21, 2016
|
|
Date collapse logic help needed
|
|
0
|
598
|
April 20, 2016
|
|
How to make this function faster
|
|
3
|
660
|
April 20, 2016
|
|
Creating an XML document within SQL - Attributes
|
|
9
|
1401
|
April 19, 2016
|
|
Night shift Hours calculation
|
|
14
|
9206
|
April 19, 2016
|
|
Performance tuning
|
|
4
|
1032
|
April 19, 2016
|
|
Too many rows returned in join statement
|
|
5
|
1180
|
April 19, 2016
|
|
Cluster behavior of Timeseries
|
|
3
|
802
|
April 19, 2016
|
|
Searching in PDF-files with Full Text Indexes
|
|
0
|
800
|
April 19, 2016
|
|
Read Txt file that is varchar and put in column of smallint
|
|
1
|
606
|
April 19, 2016
|
|
Separating column values
|
|
3
|
691
|
April 18, 2016
|