Follow along with the video below to see how to install our site as a web app on your home screen.
Note: This feature may not be available in some browsers.
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