Try using insert into ... select statements

-----Original Message-----
From: sql language digest [mailto:sql_language@p...]
Sent: Tuesday, August 22, 2000 12:31 PM
To: sql_language digest recipients
Subject: sql_language digest: August 21, 2000


sql language Digest for Monday, August 21, 2000.

1. Multipul 'Select INTO' into the same table

----------------------------------------------------------------------

Subject: Multipul 'Select INTO' into the same table
From: "Chris Browning" <chris_browning@m...>
Date: Fri, 18 Aug 2000 23:9:48
X-Message-Number: 1

I'm trying to do a Select INTO #TempTable, multipul times.

Example :-------

Select *
Into #TempTable
From a

Select *
Into #TempTable
From b
Where

---------------
I have several Tables I would like to get data from and insert the data
into the #TempTable

Every time I do a Select INTO it drops all the info previously in
#TempTable.

Is there a way to preserve the Data in a Temporary table and insert new
data with a Select INTO.

Thank you,
Chris



---

END OF DIGEST

---