Home Forums SQL Server 2008 SQL Server Newbies Creating a CASE login within a CASE logic RE: Creating a CASE login within a CASE logic

  • September 25, 2013 at 8:37 am

    #1653201

    Sorry -

    What I am trying to achieve is a CASE within a CASE I suppose

    Two conditional checks ...

    So ...

    SUM ( CASE field_SEX WHEN "MALE" THEN

    CASE field_PARENTS_ALIVE WHEN "YES" Then 1 ELSE 0 END) ELSE 0 END ) as MaleParents

    SUM ( CASE field_SEX WHEN "FEMALE" THEN

    CASE field_PARENTS_ALIVE WHEN "YES" Then 1 ELSE 0 END) ELSE 0 END ) as FeMaleParents

    Does that make more sense ?

    ________________________________________________________________________________________________
    Regards
    Steve
    SQL 2008 DBA/DBD - MCTS/MCITP

    Please don't trust me, test the solutions I give you before using them.