|
Embedding SELECT statement into WHERE clause
|
|
4
|
966
|
April 26, 2016
|
|
Query throws error when adding a WHERE condition
|
|
4
|
1097
|
April 26, 2016
|
|
SELECT Statement with AND Operator Confusion
|
|
4
|
736
|
April 26, 2016
|
|
Calculating downtime
|
|
9
|
1678
|
April 26, 2016
|
|
Xml encoding
|
|
0
|
641
|
April 26, 2016
|
|
Query: Find Duplicates not identically
|
|
0
|
504
|
April 26, 2016
|
|
Bradford Factor calculation
|
|
2
|
1077
|
April 24, 2016
|
|
CTE - create range values
|
|
1
|
668
|
April 23, 2016
|
|
Selecting parent records and child but leaving fields blank
|
|
2
|
806
|
April 23, 2016
|
|
NOT EXISTS Using IN
|
|
5
|
1009
|
April 23, 2016
|
|
SQL Coalesce or other Option?
|
|
2
|
743
|
April 23, 2016
|
|
Case with Substring return more than 1 value?
|
|
2
|
835
|
April 23, 2016
|
|
Multiple row value as Column value
|
|
4
|
978
|
April 23, 2016
|
|
Select with alternate value
|
|
5
|
960
|
April 22, 2016
|
|
Update table with values from another one (only for results that have been previously generated)
|
|
4
|
845
|
April 21, 2016
|
|
Update HH:MM:SS to Seconds
|
|
2
|
669
|
April 21, 2016
|
|
EXCLUDE field from GROUP BY when processing SUM
|
|
3
|
1190
|
April 21, 2016
|
|
MERGE INTO with SCD Type2 FROM Historical Table
|
|
1
|
826
|
April 21, 2016
|
|
Adding business hours to a datetime field
|
|
1
|
2221
|
April 21, 2016
|
|
Simple Update - Error?
|
|
3
|
519
|
April 21, 2016
|
|
Date collapse logic help needed
|
|
0
|
600
|
April 20, 2016
|
|
How to make this function faster
|
|
3
|
662
|
April 20, 2016
|
|
Creating an XML document within SQL - Attributes
|
|
9
|
1408
|
April 19, 2016
|
|
Night shift Hours calculation
|
|
14
|
9213
|
April 19, 2016
|
|
Performance tuning
|
|
4
|
1041
|
April 19, 2016
|
|
Too many rows returned in join statement
|
|
5
|
1196
|
April 19, 2016
|
|
Cluster behavior of Timeseries
|
|
3
|
812
|
April 19, 2016
|
|
Searching in PDF-files with Full Text Indexes
|
|
0
|
802
|
April 19, 2016
|
|
Read Txt file that is varchar and put in column of smallint
|
|
1
|
609
|
April 19, 2016
|
|
Separating column values
|
|
3
|
692
|
April 18, 2016
|