Hi Mich,
The input and output are just for example and it s not exact column name.
Colc not needed.
The code which I shared is working fine but need to confirm, was it right
approach and effect performance.
Thanks,
Selvam R
+91-97877-87724
On Aug 16, 2016 5:18 PM, "Mich Talebzadeh"
Hi Selvan,
is table called sel,?
And are these assumptions correct?
site -> ColA
requests -> ColB
I don't think you are using ColC here?
HTH
Dr Mich Talebzadeh
LinkedIn *
https://www.linkedin.com/profile/view?id=AAEWh2gBxianrbJd6zP6AcPCCdOABUrV8Pw
Hi All,
Please suggest me the best approach to achieve result. [ Please comment if
the existing logic is fine or not]
Input Record :
ColA ColB ColC
1 2 56
1 2 46
1 3 45
1 5 34
1 5 90
2 1 89
2 5 45
Expected Result
ResA ResB
12:2|3:3|5:5
2 1:1|5:5
I followd the below