User Profile

Collapse

Profile Sidebar

Collapse
gmadhava
gmadhava
Last Activity: Mar 29 '07, 01:05 PM
Joined: Mar 29 '07
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • gmadhava
    replied to Need help in writing a Stored Procedure
    in SQL Server
    I got the following error

    Server: Msg 1032, Level 15, State 1, Line 1
    Cannot use the column prefix 'CD'. This must match the object in the UPDATE clause 'CriticalDoctor s'.


    madhav...
    See more | Go to post

      Leave a comment:

    • gmadhava
      started a topic Need help in writing a Stored Procedure
      in SQL Server

      Need help in writing a Stored Procedure

      Hi Everybody,

      I am trying to update a column Percentage in a table named Critical Doctors with the a column named PercentTime from tblPercent table, Where the column Doctor matches with any DoctorId from tblPercent.

      I am getting an error message for the following query.

      update CriticalDoctors set Percentage =
      (select PercentTime from tblPercent)
      where CriticalDoctors .Doctor = (select DoctorId...
      See more | Go to post
      No activity results to display
      Show More
      Working...