UFN_MEMBERSHIPLEVEL_RENEWALWINDOWSTARTTIMECODE_GETID

Return

Return Type
tinyint

Parameters

Parameter Parameter Type Mode Description
@Description nvarchar(2) IN

Definition

Copy
/*
Generated by Blackbaud AppFx Platform
Date:  3/19/2013 1:11:27 AM
Assembly Version:  Blackbaud.AppFx.Platform.SqlClr, Version=3.0.504.0, Culture=neutral, PublicKeyToken=null
Copyright Blackbaud
*/
CREATE FUNCTION dbo.UFN_MEMBERSHIPLEVEL_RENEWALWINDOWSTARTTIMECODE_GETID(@Description nvarchar(2))
RETURNS tinyint WITH EXECUTE AS CALLER
AS
begin

    return case @Description
        when '1' then 0
        when '2' then 1
        when '3' then 2
        when '4' then 3
        when '5' then 4
        when '6' then 5
        when '7' then 6
        when '8' then 7
        when '9' then 8
        when '10' then 9
        when '11' then 10
        when '12' then 11
        when '13' then 12
        when '14' then 13
        when '15' then 14
        when '16' then 15
        when '17' then 16
        when '18' then 17
        when '19' then 18
        when '20' then 19
        when '21' then 20
        when '22' then 21
        when '23' then 22
        when '24' then 23
        when '25' then 24
        when '26' then 25
        when '27' then 26
        when '28' then 27
        when '29' then 28
        when '30' then 29
        when '31' then 30
        when '32' then 31
        when '33' then 32
        else -1
        end 

end