Stored Procedure returning multiple DataTables

[michael_hk]

Hi guys,

 

I am using ADO.NET and MSSQL 2000.

 

In a SP if you issue multiple "Select" statements, it will return multiple datatables. But now I just want the last result set. How can I tell MSSQL to only give me the last one? I don't want to waste bandwidth to get back the extra ones.

 

Thanks in advance.

 

Michael

[barski]

put a go command before your last select

[barski]

umm scratch that

[Derek Stone]

You'd have to modify the stored procedure with conditional statements. There's no direct way to filter a query result set.

[michael_hk]

You'd have to modify the stored procedure with conditional statements. There's no direct way to filter a query result set.

 

Thanks for the info.

 

Now I got another question. Say I have a complex Select query (may return 0 record) involving joining more than 10 tables, is it better to first use IF EXISTS () to test before doing the real Select?