Need help pivot columns to rows sql server with count : This is what I am trying to achieve in SQL server but no luck. 

I have table as below

ID	Start Dt	End Dt	Count
1	3/1/2016	6/1/2016	3


This is what I need, If Count column is 3 then I need to generate three rows

ID	Start Dt	End Dt	Count
1	3/1/2016	4/1/2016	1
1	4/1/2016	5/1/2016	1
1	5/1/2016	6/1/2016	1

Appreciate your help..

