Thanks Frank. I think you've got it but let me make sure. You're saying create the 'Create Table' statement dynamically by adding a field, (@tname) to the 'Create Table' statement during my loop then execute (@stmt) it at the end? I'm fairly new to SQL and still figuring out the syntax, what does the N in N'Create Table' do? And would I have to add the '(' after CREATE TABLE and ')' to the end of @stmt right before executing?

Thanks,

Richard.