I discovered the problem. If I used EXEC @sql I would get an error. If I used EXEC(@sql) it runs fine. Not sure what the difference is. Anyone???

Mohammed, I did read this yesterday however, when I tried to exec @sql with more than 4000 charachters it errored at the 4000 character or cut of at...

Tim, Thanks this is what I was looking for and this solved the problem but presents another one. The Select statement is more than 4000 characters long. Does NVARCHAR(MAX) cut off...