SQL Insert Simple Basic Question

[azzi2000]

Sql:
TableToUpdate = sitem, sdescription, nprice, dtdate, nver
TableToLoad = item, desc,nprice
I need to insert items From TableToload into TableToUpdate with set dtdate=#4/14/2005# ad nver=1 for the matched ones.
I am using:
Insert into TabletoUpdate
(sItem,sdescription,nprice)
select
item, desc,nprice
From TableToLoad

Please advice,
Thank you.
Dré

 

[dbomrrsm]

Insert into TabletoUpdate
(sItem,sdescription,nprice)
select
item, [desc],nprice
From TableToLoad
WHERE dtdate = =#4/14/2005#
and nver=1

[blue]DBomrrsm[/blue]

[blue]Software code, like laws and sausages, should never be examined in production[/blue][black] - [/black][purple]Edward Tenner[/purple]

 

[azzi2000]

Thank you for your response.
I was able to figure it out
That is the code used:

Insert into TabletoUpdate
(sItem,sdescription,nprice,dtdate,nver#,1)
select
item, [desc],nprice,#4/14/2004#,1
From TableToLoad

Thank you.
Dré