Run Code
|
API
|
Code Wall
|
Users
|
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
Please
log in
to post a comment.
Xml Excercise 2
Stored procedure ex1
test
Demo
test22
correlated subquery & top & view & derived table & group by
SQL HW 1 Appline
Primeiro
Employee database
social
Please log in to post a comment.