mirror of
https://github.com/acedanger/budget-database.git
synced 2025-12-05 14:40:14 -08:00
15 lines
327 B
Transact-SQL
15 lines
327 B
Transact-SQL
use Leo
|
|
go
|
|
|
|
create FUNCTION dbo.tvf_GetHolidays(@year int)
|
|
RETURNS TABLE
|
|
AS
|
|
RETURN (
|
|
select dt, dbo.fn_GetHoliday(dt) as Holiday
|
|
from (
|
|
select dateadd(day, number, convert(varchar,@year) + '-01-01') dt
|
|
from master..spt_values
|
|
where type='p'
|
|
) d
|
|
where year(dt) = @year and dbo.fn_GetHoliday(dt) is not null
|
|
) |