March 8, 2006 at 7:43 am
I want to create a series of temporary tables of identical structure, perform the same processing on each, and then insert the combined results into one super-table for display. To do the 'same processing' on each one, I need to pass each table to a subroutine of some sort (stored proc? UD function?) and get the enhanced table returned.
This could be done by passing a cursor to a stored proc, but the processing involved is set-based, e.g. summing one column, so this would be wasteful of processing time and inelegant.
A table-valued function could return a table but it can't be passed one as everything else has to be defined locally.
Any ideas out there?
March 8, 2006 at 7:51 am
Why not simply create one temp table with the same structure, then add an InstanceId column to it? This column could be 1 for data in the first temp table, 2 for data in the second and so on.
March 9, 2006 at 3:47 am
I've spent so much time looking for complicated solutions, ... as far as this piece of work goes, I think that will probably do the trick! Thanks a lot.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy