Possible Duplicate:
how to split data
I have some data in following structure in one table.I want to split the data such a way where ac_no wise database will create means if ac_no is 5 then databasename will be AC005 & part_no wise table will be created means if one ac_no, 6 part is there then it will create 6 part table with name AC005PART001,AC005PART002,AC005PART003 WITH IN THIS AC DATABASE
AC_NO PART_NO SLNOINPART SECTION_NO
5 1 660 1
5 1 662 1
5 2 663 1
5 3 664 1
5 4 666 1
5 2 668 1
5 1 669 1
5 3 670 1
5 4 671 1
5 1 672 1
5 2 674 1
5 3 675 1
5 4 676 1
6 1 677 1
6 1 678 1
6 2 679 1
6 2 680 1
6 33 681 1
6 5 682 1
6 6 683 1
6 3 684 1
6 8 685 1
6 1 687 1
6 2 688 1
6 1 689 1
6 3 690 1
6 1 691 1
6 1 693 1
6 1 694 1
6 1 696 1
