you've to use seperate insert statements for that
insert into table3(id,name,ref,amount) select id,name,ref,amount from table where name = 'B'
insert into table4(id,name,ref,amount) select id,name,ref,amount from table where name = 'C'
...
------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/
Copy rows from one table to multiple tables
Posted - 05/05/2012 : 01:34:34
