spDefaultFundraiserTemplateID

CREATE Procedure [dbo].[spDefaultFundraiserTemplateID]
    (
    @ClientsID int
    )
AS
BEGIN
DECLARE @ID int
SELECT TOP 1 @ID= [ID] 
FROM [dbo].EmailTemplate 
WHERE ClientsID = @ClientsID
AND IsInternalUse = 1 
AND Type = 4
IF @@ROWCOUNT = 0
    BEGIN
        DECLARE @OwnerID int
        SET @OwnerID = (
            SELECT TOP 1 [id] 
            FROM ClientUsers
            WHERE internaluser = 1
            ORDER BY [id] ASC)

        INSERT INTO EmailTemplate
        (ClientsID, [Name], OwnerID, Priority, Type, IsInternalUse)
        VALUES
        (@ClientsID, 'Fundraiser Defaults', @OwnerID, 3, 4, 1)
        SET @ID = SCOPE_IDENTITY()
    END

SELECT @ID
END