Update Temp Table From Temp Table Results

[sross81]

I have the temp table #ProviderReportCardTable_MeasureCounts that gets populated in my stored procedure in a step before the below code. I have confirmed that it does include all of the data that I want.

Then I have another temp table that is created #ProviderReportCardTable_MeasureCountsFINAL in another step that inserts some basic details (what I use in the join below) which does work and then the rest of it is supposed to be updated based on a join.

The problem is that none of the fields that are supposed to be updated get a value. They remain NULL. Can you update a temp table from another temp table? I have been searching for examples and I have not found one.

Update #ProviderReportCardTable_MeasureCountsFINAL
Set
AMI1Passed = p.AMI1Passed
,AMI1Failed = p.AMI1Failed
,AMI1Total = p.AMI1Total
,AMI2Passed = p.AMI2Passed
,AMI2Failed = p.AMI2Failed
,AMI2Total = p.AMI2Total
from #ProviderReportCardTable_MeasureCounts p
join #ProviderReportCardTable_MeasureCountsFINAL f on f.QtrDesc = p.QtrDesc and f.MorriseyID = p.MorriseyID

 

[mdlueck]

Can you update a temp table from another temp table? I have been searching for examples and I have not found one.

As long as the temp tables exist in the context of a single Stored Procedure, I would not think issuing UPDATE statements would not be supported.

 

[sross81]

It is all in the same stored procedure. It just doesn't seem to get results. I will keep experimenting. If anyone has any experince with this problem please share. Thank you!

 

[sross81]

It turned out I just had my join wrong. There was no matching fields for it to join because I was joining on a custom field I created in my temp table to a custom field in the other temp table, but one had a space and the other didnt.