I have a case where I have two identical tables in the database. I want to create a stored procedure which returns me the union of the result sets returned for a query when fired individually at each table.
I have a case where I have two identical tables in the database. I want to create a stored procedure which returns me the union of the result sets returned for a query when fired individually at each table.
i think you're pretty close to the solution.
Take a look at BOL for UNION
Cheers,
Frank
-- Frank Kalis Microsoft SQL Server MVP Webmaster: http://www.insidesql.org/blogs My blog: http://www.insidesql.org/blogs/frankkalis/[/url]
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply