"John Bell" wrote:

> Hi Ishan
>
> Make sure that you set NOCOUNT ON in the procedure, and if you are using ADO
> use the NextResultSet function to move to the next one.
>
> John
>
> "Ishan Bhalla" wrote:
>
> > I am calling an SP from VB which returns 2 result sets.
> > I use the 1 result set within the SP and use it to populate a TMP table
> > which participates in a join in the second select statement.
> >
> > The sp runs fine from query analyser, but from VB I always get an empty
> > recordset!
> >
> > Any suggestions?
> > Regards,
> > Ishan