Chris,

Thanks for the suggestion! I'm not sure a database snapshot would work for me in this case because the target database is a slightly different structure from the source database.

I'm...

Phil,

Thank you .That makes perfect sense. That's a good solution to the 'no data available' issue. Now it's a question of whether I want to truncate/re-populate or try to work...

Phil,

Thanks for the reply. I hadn't thought to use synonyms. Do you have a link to an example of how I would use a synonym in this way. I'm close...

All,

Thanks for your responses! Jeff, if I'm understanding your comment correctly, I'm not sure there's a way to do that...

https://dba.stackexchange.com/questions/5468/can-i-enable-sqlcmd-mode-from-inside-a-script

Mike

That makes senses. Thanks again.

Mike

Actually, I take that back. You wouldn't have a @currentValue unless you used a loop.

It would seem to avoid the loop, the parameters would have to be parsed into their...

Ah, got it. Thank you.

Mike

Scott,

Would you mind giving a simple example of how you would do this based on the values in the parameter and using UNION ALL?

Thanks,

Mike

I'm not sure if this helps (and it's not the prettiest thing) but here is a sample structure and some sample data to demonstrate what I'm trying to achieve. I...

Beatrix,

Thank you so much. I like your suggestion for creating a second job. I think that is what would be necessary to get this to work as I want. We...

Beatrix,

Thank you. This makes a lot of sense! I'll give that a try and then let you know.

Thanks again,

Mike

You'll want to look at the execution plan to determine why your query is performing poorly, but my guess is that you'll want to create a nonclustered index on the...