|
About the Transact-SQL category
|
|
0
|
1657
|
May 7, 2015
|
|
Variables passed from batch are not working in SQL Query
|
|
1
|
29
|
July 26, 2021
|
|
Insert Rows Replacing if Already Exists
|
|
7
|
66
|
July 22, 2021
|
|
Is it possible to select the name of a TVF from within it?
|
|
3
|
41
|
July 22, 2021
|
|
Can't see the Disable Trigger option in SSMS
|
|
9
|
59
|
July 21, 2021
|
|
@xml_str.modify Syntax error
|
|
8
|
39
|
July 21, 2021
|
|
Group by criteria and its repetition
|
|
2
|
54
|
July 21, 2021
|
|
Something's Wrong with My Join
|
|
7
|
51
|
July 20, 2021
|
|
Bookings to take precidence over availability
|
|
1
|
32
|
July 20, 2021
|
|
Finding the average escalation resolution time for every coder by month
|
|
7
|
72
|
July 20, 2021
|
|
Return results with the max datetime
|
|
10
|
66
|
July 16, 2021
|
|
Update column based on table join
|
|
2
|
68
|
July 14, 2021
|
|
Create a Select to select the first day of the week (Monday) in each week of the financial year
|
|
7
|
62
|
July 13, 2021
|
|
Loading 300 millions records from staging to Prod
|
|
4
|
91
|
July 12, 2021
|
|
Look for 9 consecutive identical characters
|
|
16
|
120
|
July 10, 2021
|
|
How to see if some words from a list is contained in a field and update based on the occurances
|
|
4
|
78
|
July 8, 2021
|
|
Help with SQL to look at rows and return the latest date from an array
|
|
5
|
64
|
July 8, 2021
|
|
SQL Replace problem
|
|
17
|
139
|
July 6, 2021
|
|
SQL - Select 14GB of Data into a table from staging table takes several hours
|
|
7
|
92
|
July 5, 2021
|
|
How to make transfer quantity from inventory to another inventory?
|
|
3
|
71
|
July 4, 2021
|
|
UNPIVOT help
|
|
3
|
79
|
July 3, 2021
|
|
Need help to write query
|
|
4
|
121
|
July 3, 2021
|
|
Arithmetic overflow error converting expression to data type int
|
|
11
|
118
|
July 2, 2021
|
|
Copy data from one table to another and append current year's date?
|
|
1
|
64
|
July 1, 2021
|
|
Error Converting Date Type nvarchar to Numeric
|
|
6
|
84
|
June 30, 2021
|
|
Using aliases in Common Table Expression (CTE)
|
|
14
|
108
|
June 30, 2021
|
|
Index seek 60% usage
|
|
2
|
120
|
June 29, 2021
|
|
Create view using variables
|
|
2
|
86
|
June 29, 2021
|
|
RESOLVED - Where to add the COALESCE in my code
|
|
1
|
75
|
June 29, 2021
|
|
SQL Script Help Please - Too Hard!
|
|
27
|
235
|
June 28, 2021
|
