While loop for display first 15 days of every month

Question

Hi Team How to display first and last 15 days of every month using while loop in sql server

Ankur Mistry · Answer

hope this help :https://stackoverflow.com/questions/19827148/easy-way-to-loop-over-months-and-years-from-a-given-date http://www.dreamincode.net/forums/topic/323836-display-month-and-days-using-for-loops/

Nilesh Patil · Answer

Hi Refer this link and apply in it your solution https://stackoverflow.com/questions/14602402/sql-server-while-loop-for-last-day-of-month