Hi,
Firstly thank you for taking a look at my question!
Basically I have an API I need to upload data to.
Normally fairly easy, but in this instance, I need to do separate submissions based on a common field value.
for example, say I have 4 rows in a cte called "CTE_Campaign"
FileNo Name INTNUM
1 TEST 1 4
2 TEST 2 3
3 Test 3 4
4 Test 4 1
so using the above data, in theory there would be 3 different submissions
Campaign 1 - Intnum4
FileNo Name INTNUM
1 TEST 1 4
3 Test 3 4
Campaign 2 - Intnum3
FileNo Name INTNUM
2 TEST 2 3
Campaign 3 - Intnum1
FileNo Name INTNUM
4 Test 4 1
It actually helped writing it out here to make it clearer as to what I need to do, but could someone give me a bit of guidance as to how to proceed with this?
many thanks!
Our community of experts have been thoroughly vetted for their expertise and industry experience.