USP_GET_CHANGE_EMAILADDRESS_EMAIL_DEFAULTTEMPLATEID

create procedure dbo.USP_GET_CHANGE_EMAILADDRESS_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='Change Emailaddress 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, 'Change Emailaddress Email Default Template', @OwnerID, 3, 1, 1, @ClientSitesID)
     SET @ID = SCOPE_IDENTITY()
END
SELECT @ID
END