Here is the code for the stored procedure referenced above.
create procedure dbo.ProblemNoResponse
@errorcode varchar(1) out
as
declare @countrows numeric(20)
declare @errormessage varchar(10)
select @countrows=count(*) from fin_xferhold
if ( @countrows= 0 )
begin
set @errorcode= 1
end
else
begin
if ((select distinct...