Create a Cartesian product of all records of a table using a set of predefined values, Sql Server

Create a Cartesian product of all records of a table using a set of pr...

Language: Layout:

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

edit mode | history

  
Name
Val
myDate

1
A
10
2017-01-01

2
A
10
2017-02-01

3
A
10
2017-03-01

4
B
5
2017-01-01

5
B
5
2017-02-01

6
B
5
2017-03-01

7
C
12
2017-01-01

8
C
12
2017-02-01

9
C
12
2017-03-01

λ

                                      .NET NoSQL database for rapid development