USP_STYLESHEETCLASSES_DELETE

CREATE procedure dbo.USP_STYLESHEETCLASSES_DELETE
(
  @StyleSheetID int,
  @ClassName nvarchar(255),
  @CHANGEAGENTID uniqueidentifier = null
)
as
begin
  declare @sheetClassID int
  set @sheetClassID = 0

  if @CHANGEAGENTID is null
    exec dbo.USP_CHANGEAGENT_GETORCREATECHANGEAGENT @CHANGEAGENTID output

  select top 1 @sheetClassID = sc.ID from dbo.StyleSheetClasses sc
    inner join dbo.CSSClasses c on sc.CSSClassID = c.ID
    where sc.StyleSheetID = @StyleSheetID and c.ClassName = @ClassName

  if @sheetClassID <> 0
  begin
      delete from dbo.StyleSheetClasses where ID = @sheetClassID
  end
    return 0;
end