Prakash (12/3/2007)
Dear AllI want the output in this way
Days No of.Requests
Mon 5
Tue 6
Wed 7
Thu 3
Fri 2
Sat 1
I will pass only the date to the query
Pls help me to solve this problem
Hmm, having misunderstood your original question (and suspecting that I'm not alone), and being curious enough about the problem, I'm wondering if you could explain it in more detail. Jeff Moden has a brilliant guideline about how to describe your question so that you can get a result you are happy with quickly 🙂 You can access this on http://www.sqlservercentral.com/articles/Best+Practices/61537/
Regards,
Andras