Run Code
|
API
|
Code Wall
|
Misc
|
Feedback
|
Login
|
Theme
|
Privacy
|
Patreon
MLK Date
declare @check_date datetime, @FirstDayOfYear datetime set @check_date = '01-01-2024' SELECT @FirstDayOfYear = DATEADD(yy, DATEDIFF(yy,0,@check_date) , 0 ) SELECT DATEADD(DAY, 14 , DATEADD(WEEK, DATEDIFF(WEEK, 0, DATEADD(DAY, 6 -DATEPART(DAY, @FirstDayOfYear ), @FirstDayOfYear)),0))
run
|
edit
|
history
|
help
0
Arif
Finding Row Wise Max Value From Table
securing critical sections with manual locks in sql server
BC160401693
string splitter
subquery & correlated subquery & "is null" condition
Second Query
Task_4_Final
Exam_3_Final
№2