Lots of food for thought here, thanks. The table has existed for awhile, so I certainly have data to test with - it's got about 3 million rows and growing...

Thanks for the suggestions. That is direction I've been leaning. But that then leads to the question of what is the best method for copying out the data to another...

Thanks again for all the replies. I think the idea of a stored proc that includes the insert statement followed by an update statement might work. It seems like it...

Thanks for the replies. I realize the design of the table is quite de-normalized, in fact, there are a number of other columns I left out to simplify the example....

Thanks for your response.

Unfortunately, I can't control whether or not the data I'm pulling is located on the same server as my data warehouse or on a linked server, since...

Thanks Craig. You're exactly right - I just changed the Linked Server and Database Names. In this case, yes, where I say "LinkedServer" it is referring to the same linked...

Thanks Lowell.

There is no where clause in the query and no parameters. I am trying to pull all the values into a view in my data warehouse.

The value for {0}...