Duplicate Resluts

God day! I am running an extract of our Rolodex and including some user-defined fields, as you can below: The problem I have is that I am getting duplicate results when a Rolodex e

Solution 1:

If you are getting duplicated rows, then one of your joins are finding multiple matches. Additionally, your case statement looks incorrect (possibly). Normally should be one instead of three.

CASE
    WHEN
        attr.UDA_AUTO_KEY = 24
            THEN
                'Bell Owner or Operator'
    WHEN
        attr.UDA_AUTO_KEY = 26
            THEN
                'Fixed Wing'
    WHEN
        attr.UDA_AUTO_KEY = 25
            THEN
                'Rotorcraft'
END AS [ColumnNameForThis],