I'm not sure if this is possible but here's what I'd like to do.
I'll like to create a store procedure that takes data from 3 tables and put that data into a "temporary table". Then I want to return the data from the temporary table?
For example. I have three tables called PartsCT, PartsNY, PartsNJ that each have columns named ID, PartName, PartID. Can I take the data from all three of these tables and put it in a temporary table called "PartsALL" and then have my stored procedure return the PartsALL table?
Is this possible? If so, can you provide and example of how I could do this? Thanks!