Hello,
Can someone help me with this query...I want to update the leadactivities column based on a value from another table.Please help.
Code:
UPDATE    tblLeadActivities SET f_activityName =  (SELECT     f_activityName
  FROM          tblStandardActivities) WHERE     (f_leadId = '0602HOUS3')
I am using SQL EXPRESS 2005 with Asp.Net 2.0..the latest one.Please help me,Thanks so much muchhhhh.