• hoseam (8/25/2014)


    Yes Scheme Code is s_code is the table.

    OK, but none of the codes - error_code or schema_code - from the sample data appear in your result set.

    Why is this?

    To me it seems you could just query your table like this:

    SELECT DISTINCT schema_code, error_code

    FROM error_staging;

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP