USP_ATTRIBUTECATEGORY_FLAGFORDELETE

                CREATE procedure dbo.USP_ATTRIBUTECATEGORY_FLAGFORDELETE
                (
                    @ID uniqueidentifier,
                    @CHANGEAGENTID uniqueidentifier
                )
                as begin
                    declare @CURRENTDATE datetime = getdate();

                    begin try
                        -- Make sure that the attribute category can be deleted

                        exec dbo.USP_ATTRIBUTECATEGORY_VALIDATECATEGORYDELETE @ID;

                        update dbo.ATTRIBUTECATEGORY set
                            FLAGGEDFORDELETE = 1,
                            CHANGEDBYID = @CHANGEAGENTID,
                            DATECHANGED = @CURRENTDATE
                        where ID = @ID;

                        return 0;
                    end try

                    begin catch
                        exec dbo.USP_RAISE_ERROR
                        return 1
                    end catch        
                end