Thanks Johan

Unfortunately that did not work. My results should look like this:

Your codes results look like this:

October 29, 2021 at 1:40 pm

#3945956

Thanks PB

That gives me the exact count I am currently getting with my code.

Please disregard all of those messages. It works. My apologies.

However, If I just run the first and second parts individually they work. hen I join them the 3 columns I mentioned earlier are populated with NULL

Sorry Doug I spoke too soon. After running it the FY, MRN and Race columns all have NULL's in each row

Thanks Doug

That worked perfectly

Thanks..I found that

Thanks Frederico. The MM-YYY worked and it didnt take very long. Unforunately I needed the mm-dd-yyyy for the first two. But its cool..I wont convert those two.

Thanks Sterling. I saw that when I googled it but my problem is I am not sure where that would go and how I would introduce it into the code....

My apologies, I meant 10-1994

I just removed "END AS HCPCS_CPT" from the line and now I get error message

Msg 102, Level 15, State 1, Line 24

Incorrect syntax near '='.

Thanks Cebisa. I did that and I get this new error message

Msg 156, Level 15, State 1, Line 24

Incorrect syntax near the keyword 'AS'. Here is what I did.

            
October 15, 2020 at 3:35 pm
            
#3797664

            
            
                                                
        

My apologies...I should have said I basically just need to know how the tables are joined. I am trying to

• Goal: Race/Ethnicity distribution by Payers

• Measures: Patient (MRN or PatientID)...