|
Adding Data to a Query
|
|
2
|
283
|
April 9, 2021
|
|
How to transform columns to rows dynamically
|
|
4
|
244
|
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
|
541
|
April 9, 2021
|
|
SQL temp tables syntax error
|
|
1
|
198
|
April 7, 2021
|
|
Help with concat data from same column
|
|
13
|
317
|
April 6, 2021
|
|
Show latest Entry with Group By and Where Clause
|
|
4
|
285
|
April 6, 2021
|
|
Help needed to design SQL Query
|
|
5
|
347
|
April 5, 2021
|
|
SUM function to SUM based on a condition
|
|
8
|
622
|
April 1, 2021
|
|
SQL pivot
|
|
2
|
228
|
March 31, 2021
|
|
Will Begin Try End Try, Begin catch End Catch won't work with "union all"
|
|
3
|
296
|
March 31, 2021
|
|
CONVERT to Date
|
|
46
|
1128
|
March 31, 2021
|
|
SQL Select Statement from another Query that is grouped
|
|
6
|
739
|
March 30, 2021
|
|
Calculate many durations between two dates
|
|
7
|
578
|
March 30, 2021
|
|
Not exists query
|
|
1
|
317
|
March 30, 2021
|
|
How to use JOIN on a non-existent record
|
|
3
|
287
|
March 30, 2021
|
|
Updating a row to implement error trapping
|
|
2
|
257
|
March 29, 2021
|
|
How to get Part Id that have part level 0 and not have map from?
|
|
1
|
313
|
March 27, 2021
|
|
Select Only the Oldest Duplicate Record
|
|
8
|
1894
|
March 26, 2021
|
|
Show 3 or more occurrences within a 24 hour period
|
|
2
|
220
|
March 26, 2021
|
|
Comparing values between tables and if same then use a different field?
|
|
1
|
240
|
March 26, 2021
|
|
Calculate elapsed business/work time in hours:Minutes format
|
|
2
|
1086
|
March 25, 2021
|
|
Connect Polybase and S3
|
|
0
|
466
|
March 23, 2021
|
|
Need some help in understanding the exclusion logic in a query
|
|
6
|
356
|
March 22, 2021
|
|
Summation by Max
|
|
2
|
222
|
March 19, 2021
|
|
How to select code type 1900 and 1885 when exist at least one time per part?
|
|
2
|
450
|
March 18, 2021
|
|
How to roll up multiple dates with continuous episode on same day to a single row
|
|
8
|
400
|
March 18, 2021
|
|
String ConCat in Case when
|
|
2
|
290
|
March 17, 2021
|
|
Create hashcode or unique id for all columns in a table?
|
|
8
|
493
|
March 16, 2021
|
|
How to get partid that have two category and exist on 2000,2200?
|
|
1
|
321
|
March 16, 2021
|
|
Filtering on Alias date in "WHERE clause
|
|
6
|
4598
|
March 15, 2021
|