You're correct, i'm sorry. I was thinking of an example where technically that line couldnt have expired yet because the date hadnt past yet, but yes line 2 would also...

Yeah no problem

UniqID | Date Issued | Date Expires | Business

1...........1/1/2010..........1/1/2011.....Commerical

2...........1/1/2011..........1/1/2012.....Commercial

3...........1/1/2011..........1/1/2012.....Medical

The correct output would be the count of Ids that don't have any lines replacing them.. essentially a renewed business...

Thank you for the reply,

I kind of see what you're doing I'm trying to marry my code to yours and that gets me here, does this look right?

Select UniqID

From #Table5

WHERE...

Thank you Everyone!

Luis! I was trying to add more codes to this section would the syntax look something like this?

SELECT *

FROM #SampleData

WHERE UniqID NOT IN (SELECT UniqID

...

I don't have a problem necessarily I just want to clean up my code so I don't have these massive querys setting up temp tables at the beginning of my...

I want to find out the sum of the total new insurance policies quickly, I dont want to have to navigate an entire long list of querys to find what...