Stackoverflow - Moving T-SQL datatime column for X days overlapping UNIQUE constraint, Sql Server - rextester

Run Code | API | Code Wall | Misc | Feedback | Login | Theme | Privacy | Patreon

Stackoverflow - Moving T-SQL datatime column for X days overlapping UN...

Language: Layout:

View schema
Execution time: 0,02 sec, rows selected: 24, rows affected: 24, absolute service time: 0,17 sec

edit mode | history

  
SomeDate

1
15.03.2017 00:00:00

2
16.03.2017 00:00:00

3
17.03.2017 00:00:00

4
18.03.2017 00:00:00

5
19.03.2017 00:00:00

6
20.03.2017 00:00:00

7
21.03.2017 00:00:00

8
22.03.2017 00:00:00

9
23.03.2017 00:00:00

10
24.03.2017 00:00:00

11
25.03.2017 00:00:00

12
26.03.2017 00:00:00


  
SomeDate

1
18.03.2017 00:00:00

2
19.03.2017 00:00:00

3
20.03.2017 00:00:00

4
21.03.2017 00:00:00

5
22.03.2017 00:00:00

6
23.03.2017 00:00:00

7
24.03.2017 00:00:00

8
25.03.2017 00:00:00

9
26.03.2017 00:00:00

10
27.03.2017 00:00:00

11
28.03.2017 00:00:00

12
29.03.2017 00:00:00

λ

                                      .NET NoSQL database for rapid development