x

[Closed] how to covert data from existing structure

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:33 AM in Default

user-806 gravatar image

user-806
181 18 20 22

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

The question has been closed Mar 11, 2010 at 08:53 AM by Matt Whitfield for the following reason:


0 answers: sort voted first

New code box

There's a new way to format code on the site - the red speech bubble logo will automatically format T-SQL for you. The original code box is still there for XML, etc. More details here.

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:

x61
x46

asked: Mar 11, 2010 at 08:33 AM

Seen: 713 times

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