I am trying to convert input data like this:
then output as:
C1 C2 C3 C4
1000 1002 1004 1005
This will be in a Stored Procedure.
So far, I am dividing the number of results to see:
6 Nodes / 4 = 1 full row.
I do 2 options for output. I either have the data in the 4 columns, or I assign a column identity to it such as C1R1, C2R1
The end output from this is actually a print file and the columns need to fill them in this fashion when there are 6 or 600 items.