after some help here, as i'm not sure where to start - and i hope i explain it properly too 😉
I have a SQL data source, and it represents a tree style structure, something like:
So, looking at the sample data above there are two "parents" with 1 having 2 sub entries and the second only having 1.
Hopefully that is the structure explained OK.
I can import the data OK, however i am wanting to do other things with the data, So, my question is, what syntax do i need to loop through each record that has a "ParentSerialNumber" of 4444 for instance.
Hi All, just wanting to expand a little to help explain.
i have a SQL table - i am importing it through the script as so:
Sql SELECT t.SerialNumber as SerialNumber FROM tableName as t WHERE t.ParentSerialNumber= '4444';
So this will give me a list of all records who have a ParentSerialNumber of 4444.
What i'd then like to do is to run another SQL statement to import other records from a different table, but looping through and using each 'SerialNumber' obtained from the previous statement as a variable.