question 
Author Message
 question
Is there a easy to do this.  Lets say I have some data in one table and I
want to copy that data from one table to the other how would I do this??


Sat, 22 May 2004 04:04:08 GMT
 question

Yes. Look up the select statement in Books Online.

Zach

Quote:

> Is there a easy to do this.  Lets say I have some data in one table and I
> want to copy that data from one table to the other how would I do this??



Sat, 22 May 2004 04:11:05 GMT
 question
Hi,

A couple of options...

1.DTS

2. insert into destn_table
    select * from orig_table

Dinesh.

Quote:

> Is there a easy to do this.  Lets say I have some data in one table and I
> want to copy that data from one table to the other how would I do this??



Sat, 22 May 2004 04:17:24 GMT
 question
Dinesh,

  What about the solution used at many large companies?

3a.  Print the data from the first table.
3b.  Fax the data to an employee down the hall.
3c.  Type the data into an Excel spreadsheet, and add a nice title.
3d.  E-mail the spreadsheet to the MIS department with a
    request to have it uploaded to a table.

Steve

Quote:

> Hi,

> A couple of options...

> 1.DTS

> 2. insert into destn_table
>     select * from orig_table

> Dinesh.


> > Is there a easy to do this.  Lets say I have some data in one table and I
> > want to copy that data from one table to the other how would I do this??



Sat, 22 May 2004 04:16:47 GMT
 question
hehehhe...lets cut down a few more trees and keep everyone busy.

-oj


Quote:
> Dinesh,

>   What about the solution used at many large companies?

> 3a.  Print the data from the first table.
> 3b.  Fax the data to an employee down the hall.
> 3c.  Type the data into an Excel spreadsheet, and add a nice title.
> 3d.  E-mail the spreadsheet to the MIS department with a
>     request to have it uploaded to a table.

> Steve


> > Hi,

> > A couple of options...

> > 1.DTS

> > 2. insert into destn_table
> >     select * from orig_table

> > Dinesh.




- Show quoted text -

Quote:
> > > Is there a easy to do this.  Lets say I have some data in one table
and I
> > > want to copy that data from one table to the other how would I do
this??



Sat, 22 May 2004 04:31:25 GMT
 question
Steve,

Of course companies should do that way.

Quote:
>>> 3a.  Print the data from the first table.

can buy one printer,employ a person solely for printing purposes (post:Chief
printing professional)and another manager(post:Printing manager-in-charge)to
manage all printing operations.

Quote:
>>>> 3b.  Fax the data to an employee down the hall.

Can buy a fax machine.Employ another as "Fax recipient"(post:Chief fax
receipient in charge).

Quote:
>>>> 3c.  Type the data into an Excel spreadsheet, and add a nice title.

a large dept... a number of employees ranging from typist number 1 ---- n
with a couple of managers,a cafeteria a large number of typewriters.A feast
for your ears.
Another creative copywriter for adding fancy titles.

Quote:
>>>> 3d.  E-mail the spreadsheet to the MIS department with a
>     request to have it uploaded to a table.

T3 connection.Add a PIII machine solely for that purpose.Add another
employee who needs to check the inbox now and then(post:Inbox check
specialist)
Another one to upload it to a table(post:chief data uploader)

and if recession strikes or company revenues nosedive hire a consultant who
can advise for some sort of DBMS not before laying off all those
"specialists".

Dinesh.


Quote:
> Dinesh,

>   What about the solution used at many large companies?

> 3a.  Print the data from the first table.
> 3b.  Fax the data to an employee down the hall.
> 3c.  Type the data into an Excel spreadsheet, and add a nice title.
> 3d.  E-mail the spreadsheet to the MIS department with a
>     request to have it uploaded to a table.

> Steve


> > Hi,

> > A couple of options...

> > 1.DTS

> > 2. insert into destn_table
> >     select * from orig_table

> > Dinesh.




- Show quoted text -

Quote:
> > > Is there a easy to do this.  Lets say I have some data in one table
and I
> > > want to copy that data from one table to the other how would I do
this??



Sat, 22 May 2004 04:40:23 GMT
 question
Hello,

Following is the information about SELECT INTO t-sql in SQL Server Book
Online. Hope it helps.

===============================
Inserting Rows Using SELECT INTO
The SELECT INTO statement creates a new table and populates it with the
result set of the SELECT. The structure of the new table is defined by the
attributes of the expressions in the select list, for example:

SELECT Shippers.*, Link.Address, Link.City,

                   Link.Region, Link.PostalCode

INTO NewShippers

FROM Shippers

     JOIN LinkServer.DB.dbo.Shippers AS Link

       ON (Shippers.ShipperID = Link.ShipperID)

SELECT INTO can be used to combine data from several tables or views into
one table. It can also be used to create a new table containing data
selected from a linked server.

Allan Sun
This posting is provided "AS IS" with no warranties, and confers no rights.



Sun, 23 May 2004 11:16:10 GMT
 question
Hello,

Following is the information about SELECT INTO t-sql in SQL Server Book
Online. Hope it helps.

===============================
Inserting Rows Using SELECT INTO
The SELECT INTO statement creates a new table and populates it with the
result set of the SELECT. The structure of the new table is defined by the
attributes of the expressions in the select list, for example:

SELECT Shippers.*, Link.Address, Link.City,

                   Link.Region, Link.PostalCode

INTO NewShippers

FROM Shippers

     JOIN LinkServer.DB.dbo.Shippers AS Link

       ON (Shippers.ShipperID = Link.ShipperID)

SELECT INTO can be used to combine data from several tables or views into
one table. It can also be used to create a new table containing data
selected from a linked server.

Allan Sun
This posting is provided "AS IS" with no warranties, and confers no rights.



Sun, 23 May 2004 11:17:02 GMT
 question
Hello,

Following is the information about SELECT INTO t-sql in SQL Server Book
Online. Hope it helps.

===============================
Inserting Rows Using SELECT INTO
The SELECT INTO statement creates a new table and populates it with the
result set of the SELECT. The structure of the new table is defined by the
attributes of the expressions in the select list, for example:

SELECT Shippers.*, Link.Address, Link.City,

                   Link.Region, Link.PostalCode

INTO NewShippers

FROM Shippers

     JOIN LinkServer.DB.dbo.Shippers AS Link

       ON (Shippers.ShipperID = Link.ShipperID)

SELECT INTO can be used to combine data from several tables or views into
one table. It can also be used to create a new table containing data
selected from a linked server.

Allan Sun
This posting is provided "AS IS" with no warranties, and confers no rights.



Sun, 23 May 2004 11:17:58 GMT
 question
Hi,

The orig.post sounded as if the destination table already exists.

Dinesh.



Quote:
> Hello,

> Following is the information about SELECT INTO t-sql in SQL Server Book
> Online. Hope it helps.

> ===============================
> Inserting Rows Using SELECT INTO
> The SELECT INTO statement creates a new table and populates it with the
> result set of the SELECT. The structure of the new table is defined by the
> attributes of the expressions in the select list, for example:

> SELECT Shippers.*, Link.Address, Link.City,

>                    Link.Region, Link.PostalCode

> INTO NewShippers

> FROM Shippers

>      JOIN LinkServer.DB.dbo.Shippers AS Link

>        ON (Shippers.ShipperID = Link.ShipperID)

> SELECT INTO can be used to combine data from several tables or views into
> one table. It can also be used to create a new table containing data
> selected from a linked server.

> Allan Sun
> This posting is provided "AS IS" with no warranties, and confers no
rights.

Steve,

Of course companies should do that way.

Quote:
>>> 3a.  Print the data from the first table.

can buy one printer,employ a person solely for printing purposes (post:Chief
printing professional)and another manager(post:Printing manager-in-charge)to
manage all printing operations.

Quote:
>>>> 3b.  Fax the data to an employee down the hall.

Can buy a fax machine.Employ another as "Fax recipient"(post:Chief fax
receipient in charge).

Quote:
>>>> 3c.  Type the data into an Excel spreadsheet, and add a nice title.

a large dept... a number of employees ranging from typist number 1 ---- n
with a couple of managers,a cafeteria a large number of typewriters.A feast
for your ears.
Another creative copywriter for adding fancy titles.

Quote:
>>>> 3d.  E-mail the spreadsheet to the MIS department with a
>     request to have it uploaded to a table.

T3 connection.Add a PIII machine solely for that purpose.Add another
employee who needs to check the inbox now and then(post:Inbox check
specialist)
Another one to upload it to a table(post:chief data uploader)

and if recession strikes or company revenues nosedive hire a consultant who
can advise for some sort of DBMS not before laying off all those
"specialists".

Dinesh.


- Show quoted text -

Quote:
> Dinesh,

>   What about the solution used at many large companies?

> 3a.  Print the data from the first table.
> 3b.  Fax the data to an employee down the hall.
> 3c.  Type the data into an Excel spreadsheet, and add a nice title.
> 3d.  E-mail the spreadsheet to the MIS department with a
>     request to have it uploaded to a table.

> Steve


> > Hi,

> > A couple of options...

> > 1.DTS

> > 2. insert into destn_table
> >     select * from orig_table

> > Dinesh.




- Show quoted text -

Quote:
> > > Is there a easy to do this.  Lets say I have some data in one table
and I
> > > want to copy that data from one table to the other how would I do
this??



Sun, 23 May 2004 23:01:46 GMT
 
 [ 10 post ] 

 Relevant Pages 

1. Questions, questions and more questions...

2. QUESTION?: Swapping Table :QUESTION?

3. Newbie question... ODBC and SQL server 6.5 Question

4. QUESTION?: Swapping Table :QUESTION?

5. xp_sendmail questions (maybe another question)

6. QUESTION?: Swapping Table :QUESTION?

7. question I needd to do a restore with move for databases with filegroups - Synacx Question

8. posted newbie log backup question below (new question)

9. newB question: related tables question

10. Dumb Newbie Question datatype question

11. nettiquette question...where to post TSQL questions (MSSQL)?

12. QUESTION?: DB replication options :QUESTION?


 
Powered by phpBB® Forum Software