need help to create a query to get resultset from multiple select queries inside the procedure.

[saptek]

I have a stored procedure which is having multiple queries. I want to insert into new table from resultset of all the queries. And also I want to get new column with error message. basically i have to create error log resultset. Please let me know what to include inside the stored procedure.

 

[simian336]

What do you have so far?

Simi

 

[saptek]

I have multiple select statements with different conditions which provides some with records and some with 0 records. I want to report the results into a file or table with no headers.