compile sql server online

  
sql server version

1
Microsoft SQL Server 2012 - 11.0.2100.60 (X64) 
	Feb 10 2012 19:39:15 
	Copyright (c) Microsoft Corporation
	Express Edition (64-bit) on Windows NT 6.2 <X64> (Build 9200: ) (Hypervisor)



  
id
startdate
enddate
rn
(No column name)

1
1
1/1/2015 12:00:00 AM
1/4/2015 12:00:00 AM
1
0

2
1
1/3/2015 12:00:00 AM
1/3/2015 12:00:00 AM
2
1

3
1
1/3/2015 12:00:00 AM
1/7/2015 12:00:00 AM
3
2

4
2
1/4/2015 12:00:00 AM
1/6/2015 12:00:00 AM
1
0

5
2
1/6/2015 12:00:00 AM
1/10/2015 12:00:00 AM
2
1

6
3
1/1/2015 12:00:00 AM
1/9/2015 12:00:00 AM
1
0

7
3
1/11/2015 12:00:00 AM
1/13/2015 12:00:00 AM
2
0