великолепие нижних слоев атмосферы

create FUNCTION dbo.fn_12hours_match
(
@group tinyint, @start datetime, @end datetime
)
-- group 0 - first week morning
--group 1 - first week EVENING

RETURNS bit
AS
BEGIN
declare
@ret bit,
@night_group bit,
@week_from tinyint,
@first_day datetime,
@morning_b datetime ,
@evening_b datetime ,
@start_date datetime,
@start_time datetime,
@end_date datetime,
@end_time datetime

if datediff(hh,@start,@end) > 12
begin
set @ret = 0
return @ret
end
set @morning_b = '1900-01-01 07:00:00'
set @evening_b = '1900-01-01 19:00:00'
set @first_day = '2010-06-01'

set @start_date = convert(datetime, convert (varchar(30), @start, 101))
set @end_date = convert(datetime, convert (varchar(30), @end, 101))
set @start_time = convert(datetime, convert (varchar(30), @start, 108))
set @end_time = convert(datetime, convert (varchar(30), @end, 108))

if @start_time < @morning_b or @start_time > @evening_b
set @start_date = dateadd(d,-1,@start_date)

if @end_time < @morning_b or @end_time > @evening_b
set @end_time = dateadd(d,-1,@end_date)

set @week_from = datediff(wk,@first_day,@start_date) +1
select @night_group = case when (@week_from %2) = @group then 1 else 0 end


if @night_group = 0
begin
if @start_time < @morning_b or @start_time > @evening_b
begin
set @ret = 0
return @ret
end
if @end_time < @morning_b or @end_time > @evening_b
begin
set @ret = 0
return @ret
end
end
else
begin
if @start_time between @morning_b and @evening_b
begin
set @ret = 0
return @ret
end
if @end_time between @morning_b and @evening_b
begin
set @ret = 0
return @ret
end
end
set @ret = 1
return @ret

END

----------------------------------------------------
вызов:

SELECT
([Amount])

,[Contents],StartTime,EndTime

FROM [MinAs].[dbo].[ACCUM]
where Contents='110' and dbo.fn_12hours_match(>group 0 or 1<, StartTime,EndTime) = 1

-----------------------------

проверяй :)