create table #tmp_opornaja (id int identity( 0 , 1 ) not null primary key clustered)
go

DECLARE @i int
Set @i= 0 
while @i<= 10000 
BEGIN
	insert into #tmp_opornaja DEFAULT VALUES 
	Set @i=@i+ 1 
END
go

create table #tmp_goods_quantity (goodid int not null, quantity int not null)
go

insert into #tmp_goods_quantity values( 1 , 3 )
insert into #tmp_goods_quantity values( 2 , 5 )
insert into #tmp_goods_quantity values( 3 , 8 )
insert into #tmp_goods_quantity values( 4 , 1 )
go

SELECT
	gq.goodid As goodid,
	 1  as quantity
From
	#tmp_goods_quantity gq
	inner join #tmp_opornaja op
		on op.id<gq.quantity
go

drop table #tmp_opornaja 
drop table #tmp_goods_quantity 
go