Convert rows to columns using t-sql

Because in your case max no of ranks are fixed you can use pivot operator

or this

SELECT ID,
MAX(CASE WHEN Rnk = 1 THEN Code END) AS [1],
MAX(CASE WHEN Rnk = 2 THEN Code END) AS [2],
MAX(CASE WHEN Rnk = 3 THEN Code END) AS [3],
MAX(CASE WHEN Rnk = 4 THEN Code END) AS [4],
MAX(CASE WHEN Rnk = 5 THEN Code END) AS [5],
MAX(CASE WHEN Rnk = 6 THEN Code END) AS [6],
MAX(CASE WHEN Rnk = 7 THEN Code END) AS [7],
MAX(CASE WHEN Rnk = 8 THEN Code END) AS [8]
FROM Sample
GROUP BY ID

---

Please Mark This As Answer if it solved your issue

Please Mark This As Helpful if it helps to solve your issue

Visakh

----------------------------

My MSDN Page

My Personal Blog

My Facebook Page