|
Variation on finding duplicates
|
|
2
|
346
|
September 13, 2019
|
|
Date to BigInt
|
|
5
|
3167
|
September 12, 2019
|
|
Moving data form one column to a seperate table column
|
|
4
|
308
|
September 11, 2019
|
|
Use Postcode Query Result As Join to Another Table
|
|
4
|
530
|
September 11, 2019
|
|
Database Design and complex SQL queries?
|
|
5
|
371
|
September 11, 2019
|
|
OpenJSON into Table
|
|
2
|
287
|
September 9, 2019
|
|
Email Distribution List
|
|
1
|
684
|
September 7, 2019
|
|
Converting rows into column based on different person
|
|
3
|
381
|
September 7, 2019
|
|
To Join or Not to Join
|
|
5
|
379
|
September 6, 2019
|
|
Create Calendar table from existing ERP table
|
|
11
|
359
|
September 6, 2019
|
|
Model Regex Find Sql
|
|
1
|
315
|
September 5, 2019
|
|
How can I sum all child's values into the same column for the respective parent row
|
|
2
|
494
|
September 5, 2019
|
|
SELECT Max Num of each Col ID?
|
|
1
|
274
|
September 5, 2019
|
|
Get Working Day Number/Days Left in Month
|
|
6
|
645
|
September 4, 2019
|
|
SQL Select with a join takes too long, any alternative
|
|
5
|
324
|
September 4, 2019
|
|
Using csv to select data from sql table
|
|
3
|
317
|
September 4, 2019
|
|
SQL Code Struggle
|
|
3
|
273
|
September 3, 2019
|
|
Best way to reduce workload of queries (when memory is an issue)
|
|
2
|
392
|
September 3, 2019
|
|
Check for blank in SQL
|
|
14
|
1975
|
November 12, 2018
|
|
How do I order a list with entries like x.xy.z?
|
|
7
|
425
|
September 2, 2019
|
|
XQuery Replace
|
|
17
|
788
|
August 14, 2019
|
|
Are relationships correct?
|
|
17
|
329
|
September 1, 2019
|
|
FOR JSON (Pretty Path)
|
|
1
|
331
|
August 30, 2019
|
|
Reset the total to zero when ItemCount is >= 6
|
|
4
|
344
|
August 30, 2019
|
|
Selecting rows based in previous row
|
|
3
|
349
|
August 29, 2019
|
|
Update using mutliple Table values functions
|
|
0
|
269
|
August 29, 2019
|
|
Converting single row into multiple rows based on values in columns
|
|
11
|
520
|
August 28, 2019
|
|
Unable to Get Results from Query
|
|
9
|
335
|
August 28, 2019
|
|
Adding _1,2 3 etc to duplicates data
|
|
3
|
258
|
August 28, 2019
|
|
Sum of rounded sub-values doesn't match the total value
|
|
8
|
359
|
August 28, 2019
|