I am struggling with following issue:
Table1:
Table2:
Expected result:
Basically I want to multiple rows in dates table with rows from User table. Is it somehow possible? (using TSQL).
Advertisement
Answer
You need to apply cross join
select date,month,userid,userno from table1 cross join table2