;WITH B(id,name,col1,col2,col3) AS
(
    select 1, 'A', 'A1', 'A2', 'A3'
),
A(id, name) as
(
  select 1,'a'
  union all
  select 2,'b'
  union all
  select 3,'c'
  union all
  select 4,'d'
)
select CAST(b.id AS VARCHAR(10)) + '-' + CAST(a.id AS VARCHAR(10)) id,
    b.name + '-' + a.name name,
    b.col1,
    b.col2,
    b.col3
from B b
cross join A a

/*
id                    name col1 col2 col3
--------------------- ---- ---- ---- ----
1-1                   A-a  A1   A2   A3
1-2                   A-b  A1   A2   A3
1-3                   A-c  A1   A2   A3
1-4                   A-d  A1   A2   A3

(4 row(s) affected)
*/