I have to append a table every week.
I run a SELECT statement with some calculated fields -
about 15,000 records are in the result set.
What is the best way to append a table from a SELECT
result set?
Thanks.
Lynn.
by Lynn Penningto » Sat, 06 Dec 2003 17:11:38
I run a SELECT statement with some calculated fields -
about 15,000 records are in the result set.
What is the best way to append a table from a SELECT
result set?
Thanks.
Lynn.
by Wayne Snyde » Sat, 06 Dec 2003 18:20:20
insert into mytable select yada from othertable
Quote:> I have to append a table every week.
> I run a SELECT statement with some calculated fields -
> about 15,000 records are in the result set.
> What is the best way to append a table from a SELECT
> result set?
> Thanks.
> Lynn.
by John Bel » Sat, 06 Dec 2003 18:35:15
Bulk Insert/Copy would be applicable if the results were in an file, you may
want to use INSERT with a derived table (SELECT).
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsql...
John
Quote:> I have to append a table every week.
> I run a SELECT statement with some calculated fields -
> about 15,000 records are in the result set.
> What is the best way to append a table from a SELECT
> result set?
> Thanks.
> Lynn.
by Lynn Penningto » Sat, 06 Dec 2003 18:56:35
>insert into mytable select yada from othertable
>> I have to append a table every week.
>> I run a SELECT statement with some calculated fields -
>> about 15,000 records are in the result set.
>> What is the best way to append a table from a SELECT
>> result set?
>> Thanks.
>> Lynn.
>.
1. BULK INSERT under bulk copy?
Hi all,
I was told to check whether BULK INSERT performs logged or unlogged
operation.BOL says that the bulkcopy operations are nonlogged operations.
so does it mean BULK INSERT too comes under bulk copy or was it only bcp?
thanks in adv.,
Sara.
2. Q&A 5.0
4. FORMS_MDI_WINDOW - Catching the close event
5. Error when bulk insert follows another large bulk insert
6. How does the ODBC driver know witch database to use....
7. Bulk Delete (as opposed to Bulk Insert)
8. Looking for SQL to monitor Database space utilization
10. Open Client 10.0.2 Bulk Copy Inserting NULLs Instead of Correct Values
11. Copy, Bulk copy, fastload - Ingres II 2.0 AXM on OpenVMS 7.x
12. Copy, Bulk copy, fastload - Ingres II 2.0 AXM on OpenV MS 7.x