|
How to do conditional deletes
|
|
7
|
494
|
August 10, 2021
|
|
Check if value is whole value only
|
|
5
|
1161
|
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
|
308
|
August 7, 2021
|
|
How to populate new column by comparing one row with its next row
|
|
4
|
659
|
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
|
12903
|
August 4, 2021
|
|
SQL help - Passing a value into a sub-query
|
|
3
|
266
|
July 29, 2021
|
|
Insert Rows Replacing if Already Exists
|
|
8
|
4491
|
July 27, 2021
|
|
Variables passed from batch are not working in SQL Query
|
|
1
|
252
|
July 26, 2021
|
|
Is it possible to select the name of a TVF from within it?
|
|
3
|
289
|
July 22, 2021
|
|
@xml_str.modify Syntax error
|
|
8
|
416
|
July 21, 2021
|
|
Group by criteria and its repetition
|
|
2
|
237
|
July 21, 2021
|
|
Something's Wrong with My Join
|
|
7
|
275
|
July 20, 2021
|
|
Bookings to take precidence over availability
|
|
1
|
345
|
July 20, 2021
|
|
Return results with the max datetime
|
|
10
|
318
|
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
|
514
|
July 13, 2021
|
|
Loading 300 millions records from staging to Prod
|
|
4
|
354
|
July 12, 2021
|
|
Look for 9 consecutive identical characters
|
|
16
|
551
|
July 10, 2021
|
|
How to see if some words from a list is contained in a field and update based on the occurances
|
|
4
|
260
|
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
|
339
|
July 6, 2021
|
|
SQL - Select 14GB of Data into a table from staging table takes several hours
|
|
7
|
338
|
July 5, 2021
|
|
How to make transfer quantity from inventory to another inventory?
|
|
3
|
401
|
July 4, 2021
|
|
UNPIVOT help
|
|
3
|
224
|
July 3, 2021
|
|
Arithmetic overflow error converting expression to data type int
|
|
11
|
4361
|
July 2, 2021
|
|
Copy data from one table to another and append current year's date?
|
|
1
|
269
|
July 1, 2021
|
|
Error Converting Date Type nvarchar to Numeric
|
|
6
|
4718
|
June 30, 2021
|
|
Using aliases in Common Table Expression (CTE)
|
|
14
|
4694
|
June 30, 2021
|
|
Index seek 60% usage
|
|
2
|
271
|
June 29, 2021
|