2
There are quite a few tricks in here, hope you find it useful
create function dbo.fnGetDateRanges
(
@type char(1),
@start datetime,
@finish datetime
)
returns @ranges table(start datetime, finish datetime)
as
begin
declare @from datetime
declare @to datetime
set @from...