What's the best way of creating a empty resultset?

xtang · New User Joined: 16 Feb 2007 Posts: 2 Location: U.S.A

I am working on a Stored Procedure which needs to return up to 5 resultsets based on different conditions. In some situation, the last 2 resultsets should be non-applicable therefore I am planning to return just empty resultsets. What's the best way of handling this? I don't want to create GTT table because of the overhead involved.

Thanks for your advise

William Thompson · Posted: Fri Mar 09, 2007 4:48 am

I've got no idea what a "GTT table" is, but what constitutes an "empty resultset"? An SQL code indicating "no rows returned"?
Do not forget, you can select rows that are impossible to qualify for.