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
(comments are locked)
|


duplicate of http://ask.sqlservercentral.com/questions/4702/how-to-split-data/4742#4742 ?