|
About the Transact-SQL category
|
|
0
|
2158
|
May 7, 2015
|
|
To find sandwich holidays
|
|
12
|
1088
|
July 1, 2026
|
|
Birth year between 2 dates
|
|
8
|
45
|
June 30, 2026
|
|
Add value to a count from another count
|
|
8
|
49
|
June 19, 2026
|
|
Using Logic of Inaccessible Function
|
|
1
|
17
|
May 28, 2026
|
|
Extract pattern from a string?
|
|
8
|
6825
|
May 17, 2026
|
|
Extract string between 2nd set of repeating characters
|
|
7
|
6463
|
May 15, 2026
|
|
Sql top list
|
|
8
|
797
|
May 13, 2026
|
|
To Decide timein timeout roster after an employees actual incoming time. A case of difficult order by
|
|
3
|
269
|
May 13, 2026
|
|
Very very difficult query
|
|
9
|
372
|
May 13, 2026
|
|
Pivot Tables in SQL
|
|
6
|
146
|
May 9, 2026
|
|
Getting a sum for date ranges of 7 days when there are missing dates
|
|
7
|
117
|
May 9, 2026
|
|
Matching test dates to first entrance date
|
|
4
|
77
|
May 9, 2026
|
|
SUBSTRING Functions
|
|
5
|
116
|
May 9, 2026
|
|
Get the lowest of 3 column values greater than zero
|
|
3
|
98
|
May 9, 2026
|
|
Need To Generate Shift Rotation Weekwise Rather 7 Day Wise For The Yearmonth 202508
|
|
11
|
166
|
May 6, 2026
|
|
Missing month
|
|
21
|
431
|
May 6, 2026
|
|
How do I order a list with entries like x.xy.z?
|
|
8
|
449
|
May 4, 2026
|
|
Full outer join on every row (scaffolding)
|
|
2
|
65
|
April 26, 2026
|
|
Find gaps in start stop times on mutliple overlapping rows
|
|
9
|
92
|
April 21, 2026
|
|
SELECT COUNT(DISTINCT) returns null when nothing is found instead of 0
|
|
4
|
59
|
April 1, 2026
|
|
I need help with checking the sql query
|
|
9
|
248
|
December 12, 2025
|
|
Remove leading left zeros only
|
|
18
|
6752
|
September 23, 2025
|
|
alculate the total daily medication dosage for each patient between specified start and end dates to generate a daily report.
|
|
15
|
203
|
September 11, 2025
|
|
Find the statistical MODE
|
|
3
|
65
|
August 21, 2025
|
|
Select from a comma separated string
|
|
3
|
80
|
August 5, 2025
|
|
Compare alpha results to INT after get values from a string
|
|
7
|
89
|
July 30, 2025
|
|
Calculating Survey Scores by Month and YTD
|
|
10
|
152
|
July 30, 2025
|
|
Extract part of a string with inconsistent length
|
|
2
|
121
|
July 30, 2025
|
|
Recursive CTE Alternative
|
|
3
|
1302
|
July 30, 2025
|