Run Code
|
API
|
Code Wall
|
Misc
|
Feedback
|
Login
|
Theme
|
Privacy
|
Patreon
CTE Recursive sample
--Sql Server 2014 Express Edition --Batches are separated by 'go' declare @startdate datetime = '01-01-2013', @enddate datetime ='12-01-2016'; WITH cte (abc) AS (SELECT @startdate AS n -- anchor member UNION ALL SELECT dateadd(day, 1, abc) as n -- recursive member FROM cte WHERE abc < @enddate -- terminator ) SELECT year(abc),month(abc),day(abc) FROM cte
run
|
edit
|
history
|
help
0
select all tables from given schema
count events by 2 shift cycles using CTE
Demo
EmployeeDetails
20181117
Show slowest queries
exercise
Hotel BD
TestTaskSolutionByTania
VANYA