There is a table called #T1 in sys.tables. How can I drop it from tempdb?

name
#T__________________________________________________________________________________________________________________00000000250F
#T__________________________________________________________________________________________________________________00000000250F
#T__________________________________________________________________________________________________________________00000000250F
#T__________________________________________________________________________________________________________________00000000250F
#T__________________________________________________________________________________________________________________00000000250F
#T__________________________________________________________________________________________________________________00000000250F
#T__________________________________________________________________________________________________________________00000000250F
#T__________________________________________________________________________________________________________________00000000250F
#T__________________________________________________________________________________________________________________00000000250F
#T__________________________________________________________________________________________________________________00000000250F
#T1_________________________________________________________________________________________________________________000000001E45

Each poa and diag has a number at the end. Take a peek at this section of code from the sp. The source data always has included, a DiagnosisUrnID that...

Sorry. I copied, pasted and ran your code. This error popped up.

I ran the query inside the CTE like this................

SELECT

col

Msg 245, Level 16, State 1, Line 4

Conversion failed when converting the nvarchar value 'poa' to data type int.

Yes.

The sample data only includes the diags and poa. It does not include all the demographic data. I think I can piece things together, if I can get a solution...

Yes. That's correct.

I don't have an option to limit the number of diags. I pleaded that case a while ago.
So, with the help of you folks on a separate post,...

I got some more information from the owner of the table and was able to reduce the number of records and stick them in a temporary table. Then, join the temp...

I appologize for the confusion. I'm trying to get some financial data to tie out and I can't get out of this rat hole. The data is indexed on MRN,...

See attached.

Pardon my ignorance but, how do I copy then paste the execution plan?

I know how to find the most recent records, see my query, but it's wicked slow because of the number of records. I would have to send a few million rows...