USE [wfm]
GO
/****** Object:  UserDefinedFunction [dbo].[TimeStartSequence]    Script Date: 05/28/2010 11:05:11 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER FUNCTION [dbo].[TimeStartSequence](@ShiftSt varchar(5),@interval int)
RETURNS  int
AS
begin
    declare @SeqenceNumber int
    declare @Shift int
    if (@interval=15)
    begin
        if (@ShiftSt='00:00' or @ShiftSt='00:05' or @ShiftSt='00:10')
        begin
             set @SeqenceNumber =1
        end
        else
        begin
        set @SeqenceNumber =
        (cast(SUBSTRING( @ShiftSt ,1,2) as int) * 4)+
                    (cast(SUBSTRING(  @ShiftSt,4,2) as int)/15)+1
        end
    end
    else if (@interval=30)
    begin
        if (@ShiftSt='00:00' or @ShiftSt='00:05' or @ShiftSt='00:10')
        begin
             set @SeqenceNumber =1
        end
        else
        begin
        set @SeqenceNumber =
        (cast(SUBSTRING( @ShiftSt ,1,2) as int) * 2)+
                        (cast(SUBSTRING(  @ShiftSt,4,2) as int)/30)+1
        end
    end
        /*set @Shift=  (select right('0'+ cast((@SeqenceNumber/4) as varchar),2)+':' +
        case when (@SeqenceNumber%4)=1 then  '15'
            when (@SeqenceNumber%4)=2 then  '30'
            when (@SeqenceNumber%4)=3 then  '45'
         else '00'
         end as tm)
return @Shift*/
return  @SeqenceNumber
end