create a new table based on another table

Posted on 2012-09-20
Medium Priority
Last Modified: 2012-09-21

Please see the file attached. I will import this into SQL.  There are 4 fields:
ACCT - account number
GROUP - same note
SEQ - order in that note

I need to create a new table that can group all the notes based on ACCT, GROUP, and combine notes based on the SEQ.  So for example, for 123456, there will be have 5 rows in the new table.  thx
Question by:mcrmg
  • 2
LVL 21

Accepted Solution

Alpesh Patel earned 1400 total points
ID: 38421022
select * from Table1 into Table2

Create Table2 based on Table1 and inserts data as well.

Author Comment

ID: 38421205
tthanks for the reply.  But I need to combine rows...any ideas?  thx

Author Comment

ID: 38421707
I use @PatelAlpesh's concept and get it done.....thanks

Featured Post

Transaction-level recovery for Oracle database

Veeam Explore for Oracle delivers low RTOs and RPOs with agentless transaction log backup and transaction-level recovery of Oracle databases. You can restore the database to a precise point in time, even to a specific transaction.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

There have been several questions about Large Transaction Log Files in SQL Server 2008, and how to get rid of them when disk space has become critical. This article will explain how to disable full recovery and implement simple recovery that carries…
Hi all, It is important and often overlooked to understand “Database properties”. Often we see questions about "log files" or "where is the database" and one of the easiest ways to get general information about your database is to use “Database p…
Integration Management Part 2
With just a little bit of  SQL and VBA, many doors open to cool things like synchronize a list box to display data relevant to other information on a form.  If you have never written code or looked at an SQL statement before, no problem! ...  give i…

839 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question