About the Transact-SQL category
|
|
0
|
1624
|
May 7, 2015
|
Return workgroup name where the MaxDate is greater over 2 rows
|
|
3
|
37
|
April 10, 2021
|
Merge data is giving me a duplicate
|
|
6
|
42
|
April 9, 2021
|
Adding Data to a Query
|
|
2
|
52
|
April 9, 2021
|
Passing a string value when creating a trigger
|
|
4
|
33
|
April 9, 2021
|
How to transform columns to rows dynamically
|
|
4
|
30
|
April 9, 2021
|
Msg 537, Level 16, State 3, Procedure Recover_Truncated_Data_Proc, Line 113 Invalid length parameter passed to the LEFT or SUBSTRING function
|
|
5
|
52
|
April 9, 2021
|
SQL temp tables syntax error
|
|
1
|
47
|
April 7, 2021
|
Help with concat data from same column
|
|
13
|
106
|
April 6, 2021
|
Show latest Entry with Group By and Where Clause
|
|
4
|
83
|
April 6, 2021
|
Help needed to design SQL Query
|
|
5
|
96
|
April 5, 2021
|
SUM function to SUM based on a condition
|
|
8
|
93
|
April 1, 2021
|
SQL pivot
|
|
2
|
58
|
March 31, 2021
|
Will Begin Try End Try, Begin catch End Catch won't work with "union all"
|
|
3
|
63
|
March 31, 2021
|
CONVERT to Date
|
|
46
|
135
|
March 31, 2021
|
SQL Select Statement from another Query that is grouped
|
|
6
|
60
|
March 30, 2021
|
Calculate many durations between two dates
|
|
7
|
79
|
March 30, 2021
|
Not exists query
|
|
1
|
74
|
March 30, 2021
|
How to use JOIN on a non-existent record
|
|
3
|
55
|
March 30, 2021
|
Updating a row to implement error trapping
|
|
2
|
78
|
March 29, 2021
|
How to get Part Id that have part level 0 and not have map from?
|
|
1
|
58
|
March 27, 2021
|
Select Only the Oldest Duplicate Record
|
|
8
|
104
|
March 26, 2021
|
Show 3 or more occurrences within a 24 hour period
|
|
2
|
50
|
March 26, 2021
|
Comparing values between tables and if same then use a different field?
|
|
1
|
82
|
March 26, 2021
|
Calculate elapsed business/work time in hours:Minutes format
|
|
2
|
58
|
March 25, 2021
|
Query Problem
|
|
4
|
103
|
March 24, 2021
|
Connect Polybase and S3
|
|
0
|
51
|
March 23, 2021
|
Need some help in understanding the exclusion logic in a query
|
|
6
|
151
|
March 22, 2021
|
Summation by Max
|
|
2
|
78
|
March 19, 2021
|
How to select code type 1900 and 1885 when exist at least one time per part?
|
|
2
|
72
|
March 18, 2021
|