Mr. Kapsicum (12/16/2013)

---

Hi All,

I have a Table say, 'TABLE_1'. with follwing data (Dummy Data)

RatingIDParameter_Order ProjectKeyComments

792 0 251NULL

792 1 251quality has been improved of all deliverables, got appreciation from partner

792 2 251all milestones on track

792 3 251discussion in progress for salesforce team expansion team expansion plan for 2 .net resources

792 4 251no infrastructure issues

792 5 251team working on multiple business requirements and meeting all expectations of partner

792 6 251dev and qa processes are being followed in aligned with partner

827 0 598NULL

827 1 598quality has been consistent. no escalation from partner/stakeholders

827 2 598working on release called crane

827 3 598one attrition in teach support team

827 4 598this has been consistent

827 5 598we are all well conncted with delivery stake holders.

827 6 598this has been consistent

Now, As mentioned there are two ratingid 792,827.

Each Rating Id has 7 rows of data , with parameter_order from 0 to 6.

For,Parameter_order 1 to 6 i have comments and for 0 parameter_order i have NULL(or there may be '' in the column).

Now I want the column "comments" for paramete_rorder=0 to have all the concatenate value(1 t0 6) for its respective RatingID