UPDATE, SET appears twice

[Tarzan613]

update org_links
SET ENDUSER_CNT = active_ur, SET ACTIVE_ACCNTS_CNT = active_accounts
FROM #temp, #temp2
WHERE #temp.org_id = org_links.org_id, #temp2.org_id = org_links.org_id

Mistake that I'm getting is Error 156: "Incorrect sintax near a keyword SET"

 

[arrowhouse]

Remove the second 'SET'

update org_links
SET ENDUSER_CNT = active_ur, ACTIVE_ACCNTS_CNT = active_accounts
FROM #temp, #temp2
WHERE #temp.org_id = org_links.org_id, #temp2.org_id = org_links.org_id

Mistake that I'm getting is Error 156: "Incorrect sintax near a keyword SET"

 

[sunila7]

Hi,

Also

update org_links
SET ENDUSER_CNT = active_ur, ACTIVE_ACCNTS_CNT = active_accounts
FROM #temp, #temp2
WHERE #temp.org_id = org_links.org_id AND #temp2.org_id = org_links.org_id

Change comma to AND in where clause....


Sunil