Re: select then insert into tables

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Loogie <boogieloogie@xxxxxxxxx>
Date: Thu, 28 Jun 2007 14:04:04 -0300

Scott Toney wrote:

I use:
SQL = "Insert into Table1 (tcode, tdescription, ccchecked, screenorder ) "

SQL = SQL & "SELECT tCode, tDescription, 'N', 0 "

SQL = SQL & " FROM table2 "

SQL = SQL & " where tCode = " + tmpCode + " "

SQL = SQL & "group by tcode, tdescription "

what do you do if the tables are in different databases?

:L
.

References:
- Re: select then insert into tables
  - From: Scott Toney

Prev by Date: Re: Simple Task, Datatable and SQLCE
Next by Date: How do I copy a table from one SQL CE Server db into another?
Previous by thread: Re: select then insert into tables
Next by thread: string value for year "1912" gets converted into "2012"
Index(es):
- Date
- Thread