UFN_SALESDEPOSITTEMPLATE_DEPOSITDATECODE_GETID
Return
Return Type |
---|
tinyint |
Parameters
Parameter | Parameter Type | Mode | Description |
---|---|---|---|
@Description | nvarchar(42) | IN |
Definition
Copy
/*
Generated by Blackbaud AppFx Platform
Date: 10/27/2011 12:07:06 PM
Assembly Version: Blackbaud.AppFx.Platform.SqlClr, Version=2.92.537.0, Culture=neutral, PublicKeyToken=null
Copyright Blackbaud
*/
CREATE FUNCTION dbo.UFN_SALESDEPOSITTEMPLATE_DEPOSITDATECODE_GETID(@Description nvarchar(42))
RETURNS tinyint WITH EXECUTE AS CALLER
AS
begin
return case @Description
when 'Today' then 0
when 'Yesterday' then 1
when 'Number of days before the process run date' then 2
else -1
end
end