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
Pivot and Unpivot
CTE with recursive
Microsoft SQL Server T-SQL in 10 mn ~ Lesson 13 Subqueries vers.#3
code
Fatch data in xml format
SQL
text
Running Total
20181CSE0041
Función Borrar carácter inicial repetido