aceste 2 proceduri "se bat cap in cap":

CREATE PROCEDURE ChangeStatus

@Index bigint,

@StatusCode int,

@MessageResponse varchar(4000)

AS

declare @message varchar(255),@errormessage varchar(255),@return int,@debug int

select @return=0,@message='',@errormessage=''

if not exists (select 1 from tbl1 where MessageCode=@Index)

begin

return -10300

end

begin tran

update tbl1 set StatusCode = @StatusCode , MessageResponse=@MessageResponse where MessageCode=@Index

if(@@error!=0)

begin

rollback tran

return -10301

end

commit tran

return @return

CREATE PROCEDURE GetItemNotAuthorized

if((select top 1 Continut from VERSIUNE where Descriere = 'STOP_TRAN_OUT') != 'TRUE')

return 0

declare @message varchar(255),@errormessage varchar(255),@return int,@debug int

declare @Index bigint /*Subtransaction Code*/

select @return=0,@message='',@errormessage=''

select top 1 convert(bigint, MessageCode),MessageText from tbl1 where StatusCode = 1

order by MessageCode desc

return @return