T-SQL 'PRINT' Statement / Multiple Recordsets

I've got a SP which returns information back in the following format (when viewed as Text in SQL7' Query Analyzer) ...<br><br><font style="color:000099;">PIN = xxxyyy OWNER = Paul blaaar <br>-----------------------------------------------------------------------<br>callerCLI vp line datetimejoined <br>-------------------- ---------- ----------- --------------------------- <br> TISGVP006 26 2003-01-20 14:03:09.300<br> TISGVP008 53 2003-01-20 14:07:34.193<br>0208xxxyyyy TISGVP008 22 2003-01-20 14:08:45.430<br><br>-------------------------------END-------------------------------------<br>PIN = aaabbb OWNER = Peter Klaaaaar <br>-----------------------------------------------------------------------<br>callerCLI vp line datetimejoined <br>-------------------- ---------- ----------- --------------------------- <br>0208xxxyyyy TISGVP002 46 2003-01-20 13:24:59.723<br>01306aaabbb TISGVP002 28 2003-01-20 13:26:57.677<br><br>-------------------------------END-------------------------------------</font><br><br>Yet when I view it in <b>GRID </b>format it returns 3 seperate tabbed 'panes'<br><font style="color:000099;">Results Grid #1</font>, <font style="color:000099;">Results Grid #2</font>, and <font style="color:000099;">Messages</font><br><br><font style="color:000099;">Results Grid #1</font> shows<br><font style="color:990000;"> TISGVP006 26 2003-01-20 14:03:09.300<br> TISGVP008 53 2003-01-20 14:07:34.193<br>0208xxxyyyy TISGVP008 22 2003-01-20 14:08:45.430</font><br><br><font style="color:000099;">Results Grid #2</font> shows<br><font style="color:990000;">0208xxxyyyy TISGVP002 46 2003-01-20 13:24:59.723<br>01306aaabbb TISGVP002 28 2003-01-20 13:26:57.677</font><br><br><font style="color:000099;">Messages</font> shows<br><font style="color:990000;">PIN = xxxyyy OWNER = Paul blaaar <br>-----------------------------------------------------------------------<br><br>-------------------------------END-------------------------------------<br>PIN = aaabbb OWNER = Peter Klaaaaar <br>-----------------------------------------------------------------------</font><br><br><br>When I try to display this info on an .ASP page using the SP, all I get returned is the contents of Results Grid #1 - anybody got any idea why ?

Because ADO only grabs the first SELECT query that is returned. You would need to split up the stored procedure into 3 separate requests, or rewrite the stored procedure so that it returns only one result set. The key is in that you are returning 3 separate grids. It needs to be only one.<p> </p><p><hr size="1" width="50%" align="left" />dotNetBB Forum Developer<br><b><i>Building A Better Community, One Post At A Time</i></b><br><a href="http://www.dotnetbb.com" target="_blank">www.dotnetbb.com</a></p>