x

HOW TO CONVERT EXISTING DATA

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

more ▼

asked Mar 11, 2010 at 08:32 AM in Default

user-806 gravatar image

user-806
181 18 20 22

(comments are locked)
10|1200 characters needed characters left

0 answers: sort voted first
Be the first one to answer this question
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.

Topics:

x62
x46

asked: Mar 11, 2010 at 08:32 AM

Seen: 807 times

Last Updated: Mar 11, 2010 at 08:36 AM