Member Avatar for visweswaran28

Hi,

Consider, that I have 5 fields, In which first four fields has same value and fifth one has different value. If I retrieve these records from table it should shows first 4 fields only once and fifth fields should be appended. How can I achieve.

Eg:

field #1 field #2 field #3 field #4 field #5

101 VV BLR HOME 12K

101 VV BLR HOME 15K

101 VV BLR HOME 18K

if I retrieve means, It should come like.

101 VV BLR HOME 12K,15k,18k instead repeating all fields.

  • 2 Contributors
  • 1 Reply
  • 107 Views
  • 3 Days Discussion Span
  • Latest Post Latest Post by jbisono
Member Avatar for jbisono

Hi in this post there are two solutions for it. the first one should work if you have MSSQL 2005 and above, the last solution will work no matter what version you have. I hope that help you.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.