Post reply

Querying against a multi-ID/Value table

  • February 12, 2018 at 3:10 pm

    #1979536

    thinkink07 - Monday, February 12, 2018 2:58 PM

    I'm wanting a count of Param to get the number that meet the criteria. Your example works and I can get the count by wrapping it in a derived query. Just was't sure if there was a better way..

    I prefer CTEs to derived tables, but they are equivalent for most purposes.

    Drew

    J. Drew Allen
    Business Intelligence Analyst
    Philadelphia, PA

Viewing post 16 (of 16 total)

You must be logged in to reply to this topic. Login to reply