wendy elizabeth (6/26/2014)
I am wondering if you think this suggestion would work or do you have a better idea? The 5 different dataset will be calling the same stored procedure from the main report at the same time. In each dataset, I am going to put the results into 5 uniquely named temp tables. Would this work for me?
That... should work.
I wish I had time to dig through your code and see if there are more efficient alternatives, but I don't unfortunately. If you post it all up though someone may be able to spend some time with it and see if there are alternate approaches, however. There's plenty of good folks on this forum.
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA