PERFECT 10... waooo!!!

You drilled it so well, I Spent more than 8 hrs and was still struggling to get it rite 🙂

Can i mark this post as answer 🙂

O/P for your query and my is same, Just that the filter is applied at different place.

What i intended to get it " All the insurance companies that are listed...

This is what i tried, O/P is all the insurance companies that did some business in 2010, but i want all of them, If they have not done any business...

If i put a filter " WHERE DATENAME(YEAR,LoginDate) = '2010'

I lose out on all the insurance company, It should lost out everypossible insurance company if no value the it should...

Thanks much... that really worked, should nt hvae kept another group by clause