SQL 2008. Have no problems using 2014 on another system. Screen shots attached. Thanks for your help.

Thank you. The 'Alter' method worked, for 50 million rows it took several hours.

Thanks. The table I'm dealing with has already been created and populated with data. I'd rather not rebuild it again. Should I use the 'Alter Table' command...

Thanks again to all. This topic closed.

Sorry. Hit go too soon. To continue,

couldn't I use the same 'Where In' clause to qualify (filter) 'Sales'.empID using 'WorkForce' empID? Workforce.empID lists unique ID's. If so, can...

Thanks. Couldn't do the same 'Where IN' using

Thank you both. Great forum!

Thanks for advice. I am nearly finished with creating the scripts that will generate the test data. I have to make sure, however, that the data values are...

Thank you. Yes, I am using SSMS. Just installed it (SS Express) a week or so ago and am learning SS as I go. Should have done...

Thanks. I'm very new to SQL Server and want to do this right to get the help I very much need. Where is the Text Mode of Query...

Thank you very much for your advice. The changes you suggested corrected the syntax errors but I'm still having a problem. Here is a query that produces correct...