Posted by Jens on 09/20/05 15:34

INSERT INTO Temp
select products.name, products.notes, products.purchase_date,
products.serial_no, products.total_value, products.product_code,
products.quantity, products.product_group, products.lhs1_name,
lhs1.department, lhs1.address1, lhs1.city, lhs1.country
from products, lhs1
where products.lhs1_id = lhs1.id

if it does not exists at runtime:

SELECT
products.name, products.notes, products.purchase_date,
products.serial_no, products.total_value, products.product_code,
products.quantity, products.product_group, products.lhs1_name,
lhs1.department, lhs1.address1, lhs1.city, lhs1.country
from products, lhs1
where products.lhs1_id = lhs1.id
INTO Temp


HTH, Jens Suessmeyer.

• Next in forum: Re: IDENT_CURRENT and empty table
• Prev in forum: Re: Single quote in NVARCHAR string?
• Thread view: Re: Insert based on a select query

[Reply to this message]