This cross join example takes a sequential number in a table (e.g. 1,2,3,4,5, etc.) and add a grouping of 4 to in. So now 1 and a sub number

5/26/2016 - 4:19 AM

This cross join example takes a sequential number in a table (e.g. 1,2,3,4,5, etc.) and add a grouping of 4 to in. So now 1 and a sub number

This cross join example takes a sequential number in a table (e.g. 1,2,3,4,5, etc.) and add a grouping of 4 to in. So now 1 and a sub number of 1,2,3,4 and then 2 has a sub grouping of 1,2,3,4. I this this as an example of a master category with a sub category.

SQL Sub Category.sql

select * into RevD from (select id, revs.rev from controlTest
cross join Revs) as x

Cacher is the code snippet organizer for pro developers

We empower you and your team to get more done, faster

This cross join example takes a sequential number in a table (e.g. 1,2,3,4,5, etc.) and add a grouping of 4 to in. So now 1 and a sub number