Thanks Bhuvnesh , I will have a look at it.

😀

weitzera (7/22/2010)

---

Unfortunately, there's no way to get a variable number of rows to columns. The best you can do from within TSQL is to choose a reasonable maximum number...

This is what I have got so far.

SELECT TOP 7 RESPONSE.RESPONSE_ID , RESPONSE.PRICE ,...

weitzera (7/16/2010)

---

When you say top 5, is five constant? or do you mean top X, like you said in your title?

If you're ok with having a fixed number of...