Concatanating code

[chamilz]

I have a table which basically contain records like below

part size
1 900
1 910
1 920
2 900
2 910
3 920
3 930

i need an output in a another table concatinating size code as follow..
eg.

Part size
1 900910920
2 900910
3 920930

could u pls let me know how can i write cursor to get this result.

Thanks,

 

[dbomrrsm]

see thread183-906921

[blue]DBomrrsm[/blue]

[blue]Software code, like laws and sausages, should never be examined in production[/blue][black] - [/black][purple]Edward Tenner[/purple]

 

[chamilz]

I have a table which basically contain records like below

part size
1 900
1 910
1 920
2 900
2 910
3 920
3 930

i need an output in a another table concatinating size code as follow..
eg.

Part size
1 900910920
2 900910
3 920930

could u pls let me know how can i write cursor to get this result.

Thanks,

 

[donutman]

Did you try to modify the code from the last post in the link that DBomrrsm gave you?
-Karl

[red] Cursors, triggers, user-defined functions and dynamic SQL are an axis of evil![/red]
[green]Life's uncertain...eat dessert first...www.deerfieldbakery.com[/green]

 

[chamilz]

sorry i accidently posted my thread again...iDBomrrsm solution is fine..its working!! thanks