spDefaultAcknowledgmentTemplateID

CREATE Procedure [dbo].[spDefaultAcknowledgmentTemplateID]
(
    @ClientsID int,
    @ClientSitesID int = 0
)
AS
BEGIN
    DECLARE @ID int

    if @CLIENTSITESID <= 0
        select @CLIENTSITESID = Value from dbo.Setting where ID = 1

    SELECT TOP 1 @ID= [ID] 
    FROM [dbo].EmailTemplate 
    WHERE ClientsID = @ClientsID
    AND ClientSitesID = @ClientSitesID
    AND IsInternalUse = 1
    AND Type = 1

    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, ClientSitesID)
        VALUES
        (@ClientsID, 'Acknowledgement Defaults', @OwnerID, 3, 1, 1, @ClientSitesID)
        SET @ID = SCOPE_IDENTITY()
    END

    SELECT @ID
END