spDelete_SiteLayouts

CREATE PROCEDURE [dbo].[spDelete_SiteLayouts]                
(
  @PKID INT,
  @CurrentUsersID INT
)                
AS                   
DECLARE @Guid UNIQUEIDENTIFIER

IF (EXISTS (SELECT TOP 1 ID FROM vwSitePages WHERE (TEMPLATELAYOUTID=@PKID OR LAYOUTID=@PKID) AND DELETED=0) OR EXISTS (SELECT TOP 1 ID FROM CMSTEMPLATELAYOUT WHERE SITELAYOUTSID=@PKID)) 
BEGIN
  RAISERROR ('You cannot delete this layout because it is in use. To delete a layout, you must either delete all its templates or select different layouts for them. This includes any templates in Deleted Pages/Templates.',16,1)                
RETURN 0                
END                    
BEGIN TRANSACTION                
  DELETE FROM SITELAYOUTS WHERE ID=@PKID                               
COMMIT