- 1
- 2
- 3
- 4
- 5
- 6
- 7
- 8
declare @col int
set @col = 0
while (select count(distinct id) from #tovar) > @col
begin
set @col = (select count(distinct id) from #tovar)
insert into #tovar (ParentID, ID, ISFOLDER, Tov) select parentID, ID, ISFOLDER, DESCR from SC23(nolock) where ISMARK = 0 and PARENTID in (select id from #tovar)
end
L5D 25.08.2021 05:13 # 0