;with
T(id, rpz, lots) as
	(
	select
		id, rpz, lots
	from (values(1, '9.992', 2),(2, '89.11', 2),(3, '89.138', 3))t(id, rpz, lots)
	),
N1(n) as
	(
	select top 3
		row_number() over (order by s1.object_id)
	from
		sys.objects as s1
		cross join sys.objects as s2
	),
N2(n1,n2) as
	(
	select
		n1.n, n2.n
	from
		N1 n1
		inner join N1 n2 on n2.n <= n1.n
	)

select
	t.rpz + '-' + cast(n.n2 as char(1)) as rpz,
	t.lots
from
	T t
	inner join N2 n on n.n1 = t.lots
order by
	t.id, n.n2