USP_GETDEFAULTDIRECTORYTEMPLATEID

create procedure dbo.USP_GETDEFAULTDIRECTORYTEMPLATEID
(

@CLIENTSID int

)
AS
BEGIN
        DECLARE @ID int
      SELECT TOP 1 @ID= [ID] 
        FROM [dbo].EmailTemplate 
        WHERE ClientsID = @CLIENTSID
          AND IsInternalUse = 1 
          AND Name='Directory Defaults'
  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, 'Directory Defaults', @OwnerID, 3, 1, 1)
      SET @ID = SCOPE_IDENTITY()
    END
SELECT @ID
END