August 9, 2011 at 4:15 am
Hi Chaps,
I need to pull data from a complex DB, and consolidate it into:
MONTH, LOCATION, Metric1, Metric2, Metric3.
The month and location part are keys and would always be there, but I need to write different SQL to generate those metrics. It's all quite complex, or at least for me. And it seems too much to do inside 1 select statement.
I wonder if I should do it in parts, dump in into a temporary tables then join and select from that. Ideally though, I just wanted 1 piece of code to do this, maybe an SP.
Would anyone have any advice ? I guess it's more of a development/code structure question really.
Regards, Greg
August 9, 2011 at 4:45 am
I have an advice:
Could you please check out the link at the bottom of my signature. You will find the information about how to setup your question in the way warranting prompt and helpfull responses.
If you will provide ddl's and sample data insert script together with sample of expected results I can guarantee that you will get help in matter of minutes. Otherwise you will need to wait for someone how can read your mind to get all required details 😉
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply