|
How to populate new column by comparing one row with its next row
|
|
4
|
620
|
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
|
12831
|
August 4, 2021
|
|
SQL help - Passing a value into a sub-query
|
|
3
|
255
|
July 29, 2021
|
|
Insert Rows Replacing if Already Exists
|
|
8
|
4411
|
July 27, 2021
|
|
Variables passed from batch are not working in SQL Query
|
|
1
|
251
|
July 26, 2021
|
|
Is it possible to select the name of a TVF from within it?
|
|
3
|
288
|
July 22, 2021
|
|
@xml_str.modify Syntax error
|
|
8
|
414
|
July 21, 2021
|
|
Group by criteria and its repetition
|
|
2
|
235
|
July 21, 2021
|
|
Something's Wrong with My Join
|
|
7
|
267
|
July 20, 2021
|
|
Bookings to take precidence over availability
|
|
1
|
342
|
July 20, 2021
|
|
Return results with the max datetime
|
|
10
|
317
|
July 16, 2021
|
|
Update column based on table join
|
|
2
|
240
|
July 14, 2021
|
|
Create a Select to select the first day of the week (Monday) in each week of the financial year
|
|
7
|
497
|
July 13, 2021
|
|
Loading 300 millions records from staging to Prod
|
|
4
|
349
|
July 12, 2021
|
|
Look for 9 consecutive identical characters
|
|
16
|
519
|
July 10, 2021
|
|
How to see if some words from a list is contained in a field and update based on the occurances
|
|
4
|
258
|
July 8, 2021
|
|
Help with SQL to look at rows and return the latest date from an array
|
|
5
|
201
|
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
|
337
|
July 5, 2021
|
|
How to make transfer quantity from inventory to another inventory?
|
|
3
|
400
|
July 4, 2021
|
|
UNPIVOT help
|
|
3
|
222
|
July 3, 2021
|
|
Arithmetic overflow error converting expression to data type int
|
|
11
|
4194
|
July 2, 2021
|
|
Copy data from one table to another and append current year's date?
|
|
1
|
265
|
July 1, 2021
|
|
Error Converting Date Type nvarchar to Numeric
|
|
6
|
4588
|
June 30, 2021
|
|
Using aliases in Common Table Expression (CTE)
|
|
14
|
4500
|
June 30, 2021
|
|
Index seek 60% usage
|
|
2
|
269
|
June 29, 2021
|
|
Create view using variables
|
|
2
|
14856
|
June 29, 2021
|
|
RESOLVED - Where to add the COALESCE in my code
|
|
1
|
319
|
June 29, 2021
|
|
SQL Script Help Please - Too Hard!
|
|
27
|
640
|
June 28, 2021
|
|
How to get just the city name from an address?
|
|
8
|
3390
|
June 27, 2021
|