USP_TIMEZONEENTRYADJUSTMENTRULE_DELETE

create procedure dbo.USP_TIMEZONEENTRYADJUSTMENTRULE_DELETE
(
    @TIMEZONEENTRYID uniqueidentifier,
    @CHANGEAGENTID uniqueidentifier
)
as
begin    
    declare @ID uniqueidentifier

    declare timezone_cursor cursor local fast_forward for
        select ID from dbo.TIMEZONEENTRYADJUSTMENTRULE where TIMEZONEENTRYID = @TIMEZONEENTRYID

    open timezone_cursor;

    fetch next from timezone_cursor into @ID;

    while @@FETCH_STATUS = 0 begin
        if @ID is not null
            exec USP_TIMEZONEENTRYADJUSTMENTRULE_DELETEBYID_WITHCHANGEAGENTID @ID, @CHANGEAGENTID            

        fetch next from timezone_cursor into @ID;
    end    

    close timezone_cursor;

    deallocate timezone_cursor;    

end