Pete O'Hanlon wrote:
Unfortunately not - you have to iterate over the lot before you get the output parameter back
Ought to have guessed that really. :-O I never tried it, I generally don't bother with output parameters simply because you can't get them when you really want them, usually first! If I need something like that I often return 2 record sets, the 1st with what would be the output parameter and the 2nd with the real data - probably not ideal, but it works for me :)
Bob Ashfield Consultants Ltd Proud to be a 2009 Code Project MVP