|
Query throws error when adding a WHERE condition
|
|
4
|
1063
|
April 26, 2016
|
|
SELECT Statement with AND Operator Confusion
|
|
4
|
699
|
April 26, 2016
|
|
Calculating downtime
|
|
9
|
1623
|
April 26, 2016
|
|
Xml encoding
|
|
0
|
634
|
April 26, 2016
|
|
Query: Find Duplicates not identically
|
|
0
|
496
|
April 26, 2016
|
|
Bradford Factor calculation
|
|
2
|
1049
|
April 24, 2016
|
|
CTE - create range values
|
|
1
|
665
|
April 23, 2016
|
|
Selecting parent records and child but leaving fields blank
|
|
2
|
788
|
April 23, 2016
|
|
NOT EXISTS Using IN
|
|
5
|
985
|
April 23, 2016
|
|
SQL Coalesce or other Option?
|
|
2
|
737
|
April 23, 2016
|
|
Case with Substring return more than 1 value?
|
|
2
|
821
|
April 23, 2016
|
|
Multiple row value as Column value
|
|
4
|
972
|
April 23, 2016
|
|
Select with alternate value
|
|
5
|
943
|
April 22, 2016
|
|
Update table with values from another one (only for results that have been previously generated)
|
|
4
|
825
|
April 21, 2016
|
|
Update HH:MM:SS to Seconds
|
|
2
|
660
|
April 21, 2016
|
|
EXCLUDE field from GROUP BY when processing SUM
|
|
3
|
1133
|
April 21, 2016
|
|
MERGE INTO with SCD Type2 FROM Historical Table
|
|
1
|
811
|
April 21, 2016
|
|
Adding business hours to a datetime field
|
|
1
|
2213
|
April 21, 2016
|
|
Simple Update - Error?
|
|
3
|
509
|
April 21, 2016
|
|
Date collapse logic help needed
|
|
0
|
589
|
April 20, 2016
|
|
How to make this function faster
|
|
3
|
660
|
April 20, 2016
|
|
Creating an XML document within SQL - Attributes
|
|
9
|
1360
|
April 19, 2016
|
|
Night shift Hours calculation
|
|
14
|
9132
|
April 19, 2016
|
|
Performance tuning
|
|
4
|
1016
|
April 19, 2016
|
|
Too many rows returned in join statement
|
|
5
|
1117
|
April 19, 2016
|
|
Cluster behavior of Timeseries
|
|
3
|
784
|
April 19, 2016
|
|
Searching in PDF-files with Full Text Indexes
|
|
0
|
798
|
April 19, 2016
|
|
Read Txt file that is varchar and put in column of smallint
|
|
1
|
603
|
April 19, 2016
|
|
Separating column values
|
|
3
|
689
|
April 18, 2016
|
|
COUNT DISTINCT and GROUP BY question
|
|
5
|
1505
|
April 18, 2016
|