USP_GET_DONATION_NEWUSER_WELCOME_EMAIL_DEFAULTTEMPLATEID

create procedure dbo.USP_GET_DONATION_NEWUSER_WELCOME_EMAIL_DEFAULTTEMPLATEID  
(  

@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 Name='Donation New User Welcome Email Default Template'  
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, 'Donation New User Welcome Email Default Template', @OwnerID, 3, 1, 1, @ClientSitesID)  
     SET @ID = SCOPE_IDENTITY()  
END  
SELECT @ID  
END