born2achieve (9/30/2013)
Hi Jeff,your sample data format is perfect. This is how my data will looks like. Do you have any solutions.....
Not sure yet. I know this is taking a while to wrangle out but getting it right is always important and, because of the huge amount of data the partial Cartesian Products generate, so is performance.
I know your requirement is to return each row in Table2 for every match in Table 1 and to put those matches in a Temp Table for "later processing" but perhaps the underlying problem to this all is, what will that later process actually do with that data? We might be able to streamline what we actually need to return if we knew just a bit more about that process.
I'm off to work. I probably won't be able to reply until I get home tonight.
--Jeff Moden
Change is inevitable... Change for the better is not.