Home Page › Forums › BizTalk 2004 – BizTalk 2010 › Query on SQL adapter and Insert updategram › Re: Query on SQL adapter and Insert updategram
September 26, 2008 at 7:19 AM
#20858
I also got the same issue once and I resolved it by giving alias names for return values and selecting them from an existing table. Not sure, if it is the best solution… (Applicable only to a Stored proc)
Eg: select top 1 @Identity std_id from student