insert query issues

[onressy]

Hi i have a table called products that when in the ASP if a condition is met, i need to insert into the product table new records from vendorID=305 from the product table. so basically i'm inserting new reords that are identical to records that already exist in the table but just setting the VendorID to a new id. This is what i have which doesn't seem to work: i'm trying to insert all records for vendorID=305 into the product table with vendorID equal to 304. Any suggestions

INSERT INTO Product
(VendorID
,ProductName
,ProductDescription)
VALUES
(304, (Select
,ProductName as ProductName
,ProductDescription as ProductDescription
From Product where vendorID=305))

 

[gmmastros]

Since this is a sql query issue, I recommend you post this in the SQL Server forum. Oh wait... you already did that!

thread183-1292073

-George

Strong and bitter words indicate a weak cause. - Fortune cookie wisdom

 

[JoeAtWork]

I'm not certain, but maybe this:

INSERT INTO Product
           (VendorID
           ,ProductName
           ,ProductDescription)
      (Select 304 as NewVendorID
           ,ProductName as ProductName
           ,ProductDescription as ProductDescription
          From Product where vendorID=305)

 

[onressy]

Thanks Joe. And thanks george