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
(comments are locked)
|
duplicate of http://ask.sqlservercentral.com/questions/4702/how-to-split-data/4742#4742