Help with Case Statement - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

General SQL Server Forums

New to SQL Server Programming

Help with Case Statement

Author

Topic

eastwest
Starting Member

3 Posts

Posted - 2009-08-04 : 10:26:26

Hello,

I have the following code in my stored procedure:

[CTTitle] =(SELECT TOP 1 TITLE FROM mms.dbo.vwcommitteetermmembers WHERE ID =
      (SELECT pl.PresID FROM #PresidentList pl 
       WHERE pl.ClubCTID = (SELECT TOP 1 ID FROM mms.dbo.vwcommitteeterms ct WHERE ct.lccompanyid = d.donorcompanyId))
        AND YEAR(ENDDATE) =
                (CASE
                  WHEN MONTH(GETDATE()) IN (7,8,9,10,11,12) THEN YEAR
(GETDATE()) +1
                   ELSE YEAR(GETDATE())
                END)),
  
[CTTitle1] =(SELECT  TOP 1 TITLE FROM mms.dbo.vwcommitteetermmembers WHERE MemberID  = od.ShipToID and rank=405 
          AND YEAR(ENDDATE) =
             (CASE
              WHEN MONTH(GETDATE()) IN (7,8,9,10,11,12) THEN YEAR(GETDATE()) +1
               ELSE YEAR(GETDATE())
                END))