Sorting at different record levels
Posted: Thu Dec 20, 2012 10:43 am
Hi, currently my output is thsi way:
CLIENTID RECORDTYPE EMPNO GroupPolicynumber
ABC101 A1
ABC101 A2
ABC101 A2
ABC101 A3
ABC101 A4
ABC101 A4
ABC101 A5
ABC101 A5
ABC101 B1 7990778998
ABC101 B1 7990789734
ABC101 I1 7990778998 457893275B
ABC101 I1 7990778998 879765992A
ABC101 I1 7990789734 JHJU898977
ABC101 I2 7990778998 457893275B
ABC101 I2 7990778998 879765992A
ABC101 I2 7990789734 JHJU898977
ABC101 I2 7990789734 JHJU898977
and i need it to be sorted this way, i tried many times in many ways, i could not get, any help, wt conconetion should be used while sorting?
ABC101 A1
ABC101 A2
ABC101 A2
ABC101 A3
ABC101 A4
ABC101 A4
ABC101 A5
ABC101 A5
ABC101 B1 7990778998
ABC101 I1 7990778998 457893275B
ABC101 I2 7990778998 457893275B
ABC101 I1 7990778998 879765992A
ABC101 I2 7990778998 879765992A
ABC101 B1 7990789734
ABC101 I1 7990789734 JHJU898977
ABC101 I2 7990789734 JHJU898977
ABC101 I2 7990789734 JHJU898977
CLIENTID RECORDTYPE EMPNO GroupPolicynumber
ABC101 A1
ABC101 A2
ABC101 A2
ABC101 A3
ABC101 A4
ABC101 A4
ABC101 A5
ABC101 A5
ABC101 B1 7990778998
ABC101 B1 7990789734
ABC101 I1 7990778998 457893275B
ABC101 I1 7990778998 879765992A
ABC101 I1 7990789734 JHJU898977
ABC101 I2 7990778998 457893275B
ABC101 I2 7990778998 879765992A
ABC101 I2 7990789734 JHJU898977
ABC101 I2 7990789734 JHJU898977
and i need it to be sorted this way, i tried many times in many ways, i could not get, any help, wt conconetion should be used while sorting?
ABC101 A1
ABC101 A2
ABC101 A2
ABC101 A3
ABC101 A4
ABC101 A4
ABC101 A5
ABC101 A5
ABC101 B1 7990778998
ABC101 I1 7990778998 457893275B
ABC101 I2 7990778998 457893275B
ABC101 I1 7990778998 879765992A
ABC101 I2 7990778998 879765992A
ABC101 B1 7990789734
ABC101 I1 7990789734 JHJU898977
ABC101 I2 7990789734 JHJU898977
ABC101 I2 7990789734 JHJU898977