erm from my query, i get this (already ORDER BY):


idx data hp number
1 abc +60161111111
2 afg +60129999999
3 aop +60129999999
4 zzz +60193333333
5 yyy +60193333333
6 uuu +60193333333




how do i set the @string, where hp number are same( idx 2 & 3 are combine )

e.g @string = 'afg, aop'
@hp = '60129999999'

i'm using fetch, i stored the entire @string into another table until i get a different @hp.
how do i stop the fetch where current hp number is different with previous??then i start combine the string, store into table, then continue fetch next...

like this:

idx__data________hp number
1 __afg,aop______+60129999999
2 __zzz,yyy,uuu__+60193333333

This post has been edited by LOOOOOOL: Oct 26 2009, 11:14 AM

use pivot

pivot is to rotate the table @_@
how can it related to my problem?? i'm not very pro in SP

use 2 cursors

1st cursor
select distinct mobile from tbl

2nd cursor (within 1st cursor)
select data from tbl where mobile = @mobile

wow, nice. i go try out..thx ya

You could do everything within a single cursor as long as the records are ordered by hp number.

When the hp number in current row is different from the current hp number, save the existing hp number, names and idx number into you table. After storing the data, increment your idx, set the current hp number to the new hp number and set your string to the current data.

If the hp number in the current row is still the same as the current hp number, append the data in the current row to your string variable.

your method gona use UPDATE clause rite?? its working too...haha
just done using 2 cursor, hmm..maybe using the UPDATE method code will be shorter

I thought you were storing the new row (idx,data,hp number) in a different table based on your description. You mean you want to put the resulting row back into the original table that the cursor is based on? I don't think you can do that with a cursor in your case.

yes, stored the new row into a new table
i can update the row by append the data each time i get the same hp number from my cursor.

but now I'm using 2 cursor, for me, the code look more understandable.