|
Sorting with string_agg
|
|
2
|
10965
|
August 13, 2021
|
|
Exclude an ID if its value is non-zero for only one specific category and zero for the rest of them else include it
|
|
2
|
234
|
August 12, 2021
|
|
Help needed to do below in a single sequential execute
|
|
5
|
338
|
August 11, 2021
|
|
How to do conditional deletes
|
|
7
|
506
|
August 10, 2021
|
|
Check if value is whole value only
|
|
5
|
1226
|
August 6, 2021
|
|
Chunking based on summation of column values
|
|
1
|
203
|
August 9, 2021
|
|
How to modify query below to accept also different on value?
|
|
5
|
311
|
August 7, 2021
|
|
How to populate new column by comparing one row with its next row
|
|
4
|
709
|
August 4, 2021
|
|
How Can I automate query result and send email in excel sheet which will be running every monday with out using ssis and ssrs?
|
|
9
|
12972
|
August 4, 2021
|
|
SQL help - Passing a value into a sub-query
|
|
3
|
298
|
July 29, 2021
|
|
Insert Rows Replacing if Already Exists
|
|
8
|
4581
|
July 27, 2021
|
|
Variables passed from batch are not working in SQL Query
|
|
1
|
254
|
July 26, 2021
|
|
Is it possible to select the name of a TVF from within it?
|
|
3
|
292
|
July 22, 2021
|
|
@xml_str.modify Syntax error
|
|
8
|
419
|
July 21, 2021
|
|
Group by criteria and its repetition
|
|
2
|
249
|
July 21, 2021
|
|
Something's Wrong with My Join
|
|
7
|
275
|
July 20, 2021
|
|
Bookings to take precidence over availability
|
|
1
|
359
|
July 20, 2021
|
|
Return results with the max datetime
|
|
10
|
320
|
July 16, 2021
|
|
Update column based on table join
|
|
2
|
242
|
July 14, 2021
|
|
Create a Select to select the first day of the week (Monday) in each week of the financial year
|
|
7
|
535
|
July 13, 2021
|
|
Loading 300 millions records from staging to Prod
|
|
4
|
360
|
July 12, 2021
|
|
Look for 9 consecutive identical characters
|
|
16
|
575
|
July 10, 2021
|
|
How to see if some words from a list is contained in a field and update based on the occurances
|
|
4
|
262
|
July 8, 2021
|
|
Help with SQL to look at rows and return the latest date from an array
|
|
5
|
202
|
July 8, 2021
|
|
SQL Replace problem
|
|
17
|
354
|
July 6, 2021
|
|
SQL - Select 14GB of Data into a table from staging table takes several hours
|
|
7
|
347
|
July 5, 2021
|
|
How to make transfer quantity from inventory to another inventory?
|
|
3
|
428
|
July 4, 2021
|
|
UNPIVOT help
|
|
3
|
225
|
July 3, 2021
|
|
Arithmetic overflow error converting expression to data type int
|
|
11
|
4509
|
July 2, 2021
|
|
Copy data from one table to another and append current year's date?
|
|
1
|
273
|
July 1, 2021
|