Bala' (6/27/2013)
Things not clarified ,,More than one rows per date
how spend date was calculated
how late and half date was updTED
etc
GIVE PROPER EXPLANATION ON HOW THE DATA RESIDES , AND WHAT WAS THE BUSINESS RULES TO FRAME THE OUTPUT ..THAT SAVES A TONS OF TIME
Your just giving data and output
I am not sure if typing in bold capital letters is going to make the OP understand the importance of properly describing and presenting the question.
We have articles in SSC which we normally refer to such OP's to read and understand first.
If the OP still does not understand, I normally walk off and never waste my time.
@Immaduddin
I am not sure if you are wondering Why there is only one person trying to solve my problem and that nobody else seems to assist?
If you are not wondering so you should. SSC is a place where you get really quick help from many experts if you follow some basic rules.
If you don't follow those rules, you reduce your own chances of being helped
Hence, I would once again refer you to the same article on Forum Etiquette[/url]
If you read the article and follow some basic rules, I am sure you will get a lot more help and that too much quicker. Good luck:-)
How to post data/code on a forum to get the best help - Jeff Moden
http://www.sqlservercentral.com/articles/Best+Practices/61537/