Keep getting Time Expired when updating PWGCity column.

[derbyp]

DECLARE @PWGCitya int
UPDATE tblLeads_Info
SET tblLeads_Info.PWGCity = @PWGCitya
SELECT @PWGCitya = UPDATE_AddToPWGCity1.PWGCity
FROM tblLeads_Info INNER JOIN
UPDATE_AddToPWGCity1 ON tblLeads_Info.NameID = 645526 AND UPDATE_AddToPWGCity1.NameID = 645526

 

[gmmastros]

I think this code is not doing what you want it to. Can you explain in words what you hope to achieve here?

DECLARE @PWGCitya int 
[green] -- At this point @PWGCitya is NULL[/green]
UPDATE    tblLeads_Info
SET tblLeads_Info.PWGCity = @PWGCitya
[green] -- No where clause, so all records will be updated with null.[/green]

SELECT  @PWGCitya = UPDATE_AddToPWGCity1.PWGCity
FROM tblLeads_Info INNER JOIN
UPDATE_AddToPWGCity1 ON tblLeads_Info.NameID = 645526 AND UPDATE_AddToPWGCity1.NameID = 645526

-George

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

 

[derbyp]

I am trying to pass the value 212 from the 2 column table
UPDATE_AddToPWGCity1 to the tblLeads table with column PWGCity.

 

[derbyp]

Thank you gmmastros,
Here is the correct code for what I am doing.


UPDATE tblLeads_Info
SET PWGCity = UPDATE_AddToPWGCity1.PWGCity
FROM tblLeads_Info, UPDATE_AddToPWGCity1
WHERE (tblLeads_Info.NameID = UPDATE_AddToPWGCity1.NameID)