-
Increment Values based on column (Looping)
I have source like this Num, SeqNo,Ln,Qty 101, 1 ,1,5 I wanna target following below Num,SeqNo,Ln,Qty 101, 1 , 1, 1 101, 1 , 2, 1 101, 1 , 3, 1 101, 1 , 4, 1 101, 1 , 5, 1 Based on Qty value records will be incremented.If qty value is 4 then o/p will be like below Num,SeqNo,Ln,Qty 101, 1 , 1, 1 101, 1 , 2, 1 101, 1 , 3, 1 101, 1 , 4, 1 Please help on this. Thanks in advance.
-
How to Seperate Repetating & non-Repetating data.
I have data in Table as ID 1 2 3 1 4 3 3 5 6 6 7 Now I want to have Output as repeatating records in one table & non-repeatating in another table Table 1 : Id 2 4 5 7 Table 2: ID 1 1 3 3 3 6 6 Thanks, Sushil