create function fn_IsWeekDay
(
@date datetime
)
returns bit
as
begin
declare @dtfirst int
declare @dtweek int
declare @iswkday bit
set @dtfirst = @@datefirst – 1
set @dtweek = datepart(weekday, @date) – 1
if (@dtfirst + @dtweek) [...]
