update case field 问题
UPDATE  
      [Organization]  
SET
        CASE   @CourseTypeID   WHEN   0   THEN   [ConcurrentUserLicenses]   =[ConcurrentUserLicenses]   -   1
ELSE   InstructorLedCourseLicenses=InstructorLedCourseLicenses   -1
WHERE
        [OrganizationID]   =   @OrganizationID

我想实现的功能是这样的  
中的SET   语句怎么写呢？   谢谢

------解决方案--------------------
try

UPDATE
[Organization]
SET
ConcurrentUserLicenses = (Case When @CourseTypeID = 0 Then ConcurrentUserLicenses - 1 End),
InstructorLedCourseLicenses = (Case When @CourseTypeID != 0 Then InstructorLedCourseLicenses - 1 End)
WHERE
[OrganizationID] = @OrganizationID
------解决方案--------------------
UPDATE [Organization]
SET [ConcurrentUserLicenses]=CASE @CourseTypeID WHEN 0 THEN [ConcurrentUserLicenses] - 1
ELSE InstructorLedCourseLicenses -1 end
WHERE [OrganizationID] = @OrganizationID
语法的问题
------解决方案--------------------
UPDATE [Organization]
SET ConcurrentUserLicenses=CASE WHEN @CourseTypeID=0 THEN ConcurrentUserLicenses - 1
else ConcurrentUserLicenses end,
SET InstructorLedCourseLicenses=CASE WHEN @CourseTypeID=0 THEN InstructorLedCourseLicenses - 1
else InstructorLedCourseLicenses end
WHERE [OrganizationID] = @OrganizationID