combine multiple rows in single row

[i gr8]

Hi, I want to combine multiple rows in a single one. Have a look at the following sample. Any body know how to do this....thnx in advance original table ------------------ FID Code Value1 Value2 1 C1 20 Null 1 C1 Null 10 2 C1 30 Null 2 C1 Null 40 To -- FID Code Value1 Value2 1 C1 20 10 2 C1 30 40

[Alegria_Lee]

SELECT FID,Code,Max(Value1),Max(Value2)
FROM TableName
Group By FID,Code

[Mycroft Holmes]

You need a pivot [^] table.

Never underestimate the power of human stupidity RAH

[Blue_Boy]

Perhaps you should use MIN in any of fields for Value1 or Value2

---

I Love T-SQL "Don't torture yourself,let the life to do it for you." If my post helps you kindly save my time by voting my post. www.aktualiteti.com

[Alegria_Lee]

why MIN?