thanks

Thanks.Can we solve the problem 1 with a single t-sql statement?

Changed the example for better understanding of the problem. I need one t-sql statement to do "Split table on columns into two tables" and one t-sql statement to do...