Get all dates between two given dates, Sql Server

Get all dates between two given dates

Language: Layout:

View schema
Execution time: 0,02 sec, rows selected: 32, rows affected: 0, absolute service time: 0,22 sec, absolute service time: 0,22 sec

edit mode | history | discussion

  
sql server version

1
Microsoft SQL Server 2014 - 12.0.2000.8 (Intel X86) 
	Feb 20 2014 19:20:46 
	Copyright (c) Microsoft Corporation
	Express Edition on Windows NT 6.3 <X64> (Build 9600: ) (WOW64) (Hypervisor)



  
(No column name)

1
2011-01-01

2
2011-01-02

3
2011-01-03

4
2011-01-04

5
2011-01-05

6
2011-01-06

7
2011-01-07

8
2011-01-08

9
2011-01-09

10
2011-01-10

11
2011-01-11

12
2011-01-12

13
2011-01-13

14
2011-01-14

15
2011-01-15

16
2011-01-16

17
2011-01-17

18
2011-01-18

19
2011-01-19

20
2011-01-20

21
2011-01-21

22
2011-01-22

23
2011-01-23

24
2011-01-24

25
2011-01-25

26
2011-01-26

27
2011-01-27

28
2011-01-28

29
2011-01-29

30
2011-01-30

31
2011-01-31

λ

                                      .NET NoSQL database for rapid development