Hi Chris and Jeff thank you for the replies. i will hold these values in temp table and will be using it for further use  in joining with other tables. those first and last date of month will  be required for other operations.

Hi Chris, i got the below error. I am usingg sqlserver 2008R2

Msg 195, Level 15, State 10, Line 7
'EOMONTH' is not a recognized built-in function name