For one thing, I do not have a Tally table setup on the server in which I am working.

So, are there any other ways of doing this without a tally table. There are only about 100,000 rows, and this is a one time update. So I do not really care about performance. What I am most concerned with is the amount of time to have this completed.

Yes, I can select the data into a temp table, in separate columns there. That would be fine. I can perform the update and then do what I need.

Thanks in advance

Andrew SQLDBA