@jeff Moden :

First of all, i am very sorry for the delayed response..

it is perfectly working .. only one thing to be noted is , after...

@jeff Moden : Just now saw your solutions and the messages.. i will try it from my end and then i will let u know the result..

Thanks alot...

Hi,

i want to get the records for each month, quaterly, yearly for report generation purpose..

Hi,

the excel sheet one you attached is correct..

sql server 2008 r2 i guess it should be 64bit

Thanks

Navin