Hi all,
I have a stored procedure (called from an orchestration) that performs a lookup in a SQL Server 2005 table, returns a value and it works fine. The part I am having trouble with is how to trap the lookup when 0 rows are returned, e.g. it can't find a value in the table. Simple error checking, right?
I can add a variable in the Stored Procedure but I can't figure out how to access or read the variable in BizTalk. Anyone have an example?
Thanks.