Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi, is it possible to simplify this code, using iteration?
[Split]:DECLARE FIELD DEFINITIONFIELDSSubField($1, '/', 1) as [Part1],SubField($1, '/', 2) as [Part2],SubField($1, '/', 3) as [Part3],SubField($1, '/', 4) as [Part4],SubField($1, '/', 5) as [Part5],SubField($1, '/', 6) as [Part6],;
No. And you should almost never resort to iteration through tables. It will be sooooo much slower than doing thing inside the LOAD statement.