|
Database Design and complex SQL queries?
|
|
5
|
350
|
September 11, 2019
|
|
OpenJSON into Table
|
|
2
|
284
|
September 9, 2019
|
|
Email Distribution List
|
|
1
|
662
|
September 7, 2019
|
|
Converting rows into column based on different person
|
|
3
|
378
|
September 7, 2019
|
|
To Join or Not to Join
|
|
5
|
351
|
September 6, 2019
|
|
Create Calendar table from existing ERP table
|
|
11
|
359
|
September 6, 2019
|
|
Model Regex Find Sql
|
|
1
|
314
|
September 5, 2019
|
|
How can I sum all child's values into the same column for the respective parent row
|
|
2
|
489
|
September 5, 2019
|
|
SELECT Max Num of each Col ID?
|
|
1
|
272
|
September 5, 2019
|
|
Get Working Day Number/Days Left in Month
|
|
6
|
628
|
September 4, 2019
|
|
SQL Select with a join takes too long, any alternative
|
|
5
|
313
|
September 4, 2019
|
|
Using csv to select data from sql table
|
|
3
|
310
|
September 4, 2019
|
|
SQL Code Struggle
|
|
3
|
267
|
September 3, 2019
|
|
Best way to reduce workload of queries (when memory is an issue)
|
|
2
|
374
|
September 3, 2019
|
|
Check for blank in SQL
|
|
14
|
1969
|
November 12, 2018
|
|
How do I order a list with entries like x.xy.z?
|
|
7
|
421
|
September 2, 2019
|
|
XQuery Replace
|
|
17
|
770
|
August 14, 2019
|
|
Are relationships correct?
|
|
17
|
325
|
September 1, 2019
|
|
FOR JSON (Pretty Path)
|
|
1
|
327
|
August 30, 2019
|
|
Reset the total to zero when ItemCount is >= 6
|
|
4
|
339
|
August 30, 2019
|
|
Selecting rows based in previous row
|
|
3
|
336
|
August 29, 2019
|
|
Update using mutliple Table values functions
|
|
0
|
259
|
August 29, 2019
|
|
Converting single row into multiple rows based on values in columns
|
|
11
|
512
|
August 28, 2019
|
|
Unable to Get Results from Query
|
|
9
|
334
|
August 28, 2019
|
|
Adding _1,2 3 etc to duplicates data
|
|
3
|
257
|
August 28, 2019
|
|
Sum of rounded sub-values doesn't match the total value
|
|
8
|
357
|
August 28, 2019
|
|
Pivot Table, SQL Server 2008 R2
|
|
2
|
435
|
August 28, 2019
|
|
Hello everyone
|
|
0
|
186
|
August 28, 2019
|
|
How to recode T-SQL without using Tally Table
|
|
3
|
353
|
August 26, 2019
|
|
Get records for purchase tracking and categorize them
|
|
30
|
471
|
August 26, 2019
|