Well Basically I look at Staging.ClaCases and select the NameID for the records your query returned. This will return all the claims that this NameID has.

I focus on the columns...

The Query runs. The count is still incorrect but I'm assuming there is still another stage;-)

As for the more efficient inner join, results are lost when compared to the one...

So far so good, cqv.QuestionDate < it.discoverdate holds for all cases 🙂

The query returns results however they are incorrect. I had to change the alias cc.QuestionDate to cqv.QuestionDate...The count doesn't seem to take into account cqv.DiscoverDate < it.discoverdate...

I had a look at your code and I found something that ensures no results will be returned ie AND it.QuestionClassID = cqv.QuestionClassID

it.QuestionClassID will never be the same as cqv.QuestionClassID...

No results are returned even if I do comment out the where clause...

The code runs however the entire NoOFSOSCalls remains NULL.

I had to make one change to your code. QuestionDate is from 'cqv' and not from 'it' so I changed the alias...I...

Your query only yields results when you specify ClaQuestionHistoryID in the select ie

SELECT *

FROM (

SELECT ClaQuestionHistoryID,

...

Great thanks for the feedback;-)

Thanks once again for the feedback!!! Hopefully someone will be able to provide some assistance with the dropping of tables question:-)

I thought of something else and I'd like so feedback if possible. I know very little about stored procedures but could this possibly be used as an alternative to the...

Thanks for the info!!!

I have two related questions

1)Can I assume dropping tables will free memory as I proceed with the query? After #table_2 is created drop #table_1 etc

2)After each...

Sure thing.

Select it.*

,(Select --Find the latest ITC Score before the incident took place

...

Hi,

I was able to achieve the result I needed without the use of a cursor. Thanks again for your advice and your willingness to help.

Will definitely keep that in mind for future queries:-) Thanks