hai ,

I need to get the monthnames between 2 dates such as 01-04-2012 & 30-03-2013 .
Can you help me to get it.

Thanks in advance,
sreevidya

select datename(month,datecol) from tbl where dt between ..........