raghuldrag (7/27/2012)
hey friend my actual table ve lakhs of data per month,after making the query,I m expexting ve to display account only one time per month and its has been summarize value of that month.
The expected result that you have provided has complete duplicate rows which makes me feel that it is not summarized
Provide us the expected output based on the sample data that you have provided so that we correlate both of them and provide you tested solution
How to post data/code on a forum to get the best help - Jeff Moden
http://www.sqlservercentral.com/articles/Best+Practices/61537/