fnGetDataSourceForTemplate

Return

Return Type
int

Parameters

Parameter	Parameter Type	Mode	Description
@EmailTemplateID	int	IN

Definition

Copy



create function dbo.fnGetDataSourceForTemplate(@EmailTemplateID int)
    RETURNS int AS 
    BEGIN
        declare @DSID int
        SELECT top 1 @DSID =  DataSourceID 
        FROM dbo.emailtemplate_datasources
        WHERE emailtemplateid=@EmailTemplateID
        ORDER BY DataSourceID

        return coalesce(@DSID, 0)
    END