Microsoft, SQL, 2005, Update Script help

I want to update type of bill from 738 to 731 where the visit owner equals 6

Started it but its not going well ... any help is appreciated.

UPDATE PatientVisitFiling pvf FROM
INNER JOIN PatientVisit pv ON pvf.PatientVisitId = pv.PatientVisitId
SET pvf.TypeOfBill = '731' WHERE pv.VisitOwnerMId = '6'
LVL 7
Jeff SAsked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
dportasConnect With a Mentor Commented:
UPDATE PatientVisitFiling
SET TypeOfBill = '731'
WHERE EXISTS
(SELECT 1
 FROM PatientVisit pv
 WHERE pv.PatientVisitId = PatientVisitFiling.PatientVisitId
  AND pv.VisitOwnerMId = '6');
0
 
Patrick MatthewsConnect With a Mentor Commented:
UPDATE PatientVisitFiling
SET TypeOfBill = '731'
FROM PatientVisitFiling pvf INNER JOIN
      PatientVisit pv ON pvf.PatientVisitId = pv.PatientVisitId
WHERE pv.VisitOwnerMId = '6'
0
 
vavjeevaConnect With a Mentor Commented:
try this .. it should work

UPDATE PatientVisitFiling SET TypeOfBill = '731'  FROM PatientVisitFiling pvf
INNER JOIN PatientVisit pv ON pvf.PatientVisitId = pv.PatientVisitId
WHERE pv.VisitOwnerMId = '6'
0
 
Jeff SAuthor Commented:
Split points to be fair ....  wish i could give all full credit
0
All Courses

From novice to tech pro — start learning today.