- 01
- 02
- 03
- 04
- 05
- 06
- 07
- 08
- 09
- 10
- 11
with cteTypes (TypeId)
as (
select 4
union all select 5
union all select 6
union all select 9
union all select 1
)
select *
from dbo.SomeTable tbl
cross join ( select TypeId from cteTypes ) t ( TypeId )