|
Join table in Select Statement on UNIQUE ID to CHAR
|
|
5
|
5105
|
September 17, 2019
|
|
Grouping Distinct Column
|
|
5
|
388
|
September 17, 2019
|
|
Trigger to save and move data log
|
|
10
|
524
|
September 16, 2019
|
|
SQL Job (Execute Truncates)
|
|
5
|
335
|
September 14, 2019
|
|
SQL to compare column values
|
|
4
|
425
|
September 13, 2019
|
|
Variation on finding duplicates
|
|
2
|
346
|
September 13, 2019
|
|
Date to BigInt
|
|
5
|
3172
|
September 12, 2019
|
|
Moving data form one column to a seperate table column
|
|
4
|
309
|
September 11, 2019
|
|
Use Postcode Query Result As Join to Another Table
|
|
4
|
531
|
September 11, 2019
|
|
Database Design and complex SQL queries?
|
|
5
|
376
|
September 11, 2019
|
|
OpenJSON into Table
|
|
2
|
293
|
September 9, 2019
|
|
Email Distribution List
|
|
1
|
688
|
September 7, 2019
|
|
Converting rows into column based on different person
|
|
3
|
386
|
September 7, 2019
|
|
To Join or Not to Join
|
|
5
|
380
|
September 6, 2019
|
|
Create Calendar table from existing ERP table
|
|
11
|
359
|
September 6, 2019
|
|
Model Regex Find Sql
|
|
1
|
316
|
September 5, 2019
|
|
How can I sum all child's values into the same column for the respective parent row
|
|
2
|
496
|
September 5, 2019
|
|
SELECT Max Num of each Col ID?
|
|
1
|
274
|
September 5, 2019
|
|
Get Working Day Number/Days Left in Month
|
|
6
|
649
|
September 4, 2019
|
|
SQL Select with a join takes too long, any alternative
|
|
5
|
325
|
September 4, 2019
|
|
Using csv to select data from sql table
|
|
3
|
325
|
September 4, 2019
|
|
SQL Code Struggle
|
|
3
|
275
|
September 3, 2019
|
|
Best way to reduce workload of queries (when memory is an issue)
|
|
2
|
393
|
September 3, 2019
|
|
Check for blank in SQL
|
|
14
|
1992
|
November 12, 2018
|
|
XQuery Replace
|
|
17
|
809
|
August 14, 2019
|
|
Are relationships correct?
|
|
17
|
335
|
September 1, 2019
|
|
FOR JSON (Pretty Path)
|
|
1
|
336
|
August 30, 2019
|
|
Reset the total to zero when ItemCount is >= 6
|
|
4
|
350
|
August 30, 2019
|
|
Selecting rows based in previous row
|
|
3
|
349
|
August 29, 2019
|
|
Update using mutliple Table values functions
|
|
0
|
271
|
August 29, 2019
|