ZS
я тебе тоже форварднул
[_OLD_UNCLOSED]:
LOAD
OLD_ID AS ID,
Div(RowNo(),1000) AS CONCAT_NUM
resident [_OLD]
where IsNull(COMPLETED_AT)
2 fields found: ID, CONCAT_NUM,
[_OLD_UNCLOSED_GROUP]:
LOAD
' ID IN ('& Concat(ID,', ')&')' AS CONCAT_IDS
resident [_OLD_UNCLOSED]
Group By CONCAT_NUM
1 fields found: CONCAT_IDS,
Drop Table [_OLD_UNCLOSED]
for _i=0 to NoOfRows('_OLD_UNCLOSED_GROUP') - 1
_vUnclosedIdList = Peek('CONCAT_IDS',0,'_OLD_UNCLOSED_GROUP')
SELECT
...
WHERE 1=1
ANd (
$(_vUnclosedIdList)
)
