Hi
Use SQL to do it create a stored procedure to pass parameter use the sql below
SELECT ID,
MAX(CASE WHEN HDCOL ='HD1' THEN HDNAME END) AS HD1,
MAX(CASE WHEN HDCOL ='HD1' THEN HDSIZE END) AS SIZE,
MAX(CASE WHEN HDCOL ='HD2' THEN HDNAME END) AS HD2,
MAX(CASE WHEN HDCOL ='HD2' THEN HDNAME END) AS SIZE,
MAX(CASE WHEN HDCOL ='HD3' THEN HDNAME END) AS HD3,
MAX(CASE WHEN HDCOL ='HD3' THEN HDSIZE END) AS SIZE
FROM YOUR TABLE
GROUP BY ID
OUTPUT
ID HD1 SIZE HD2 SIZE HD3 SIZE
123 HD1 100GB HD2 200GB HD3 300GB
Cheers
Rahul
IP Logged
