pivot statement

Try this,

SELECT * FROM (
        SELECT sequence, '['+cast(fromdays as nvarchar) + '-' + cast(todays as nvarchar)+']' as concatefield FROM #tabB
) as x
PIVOT
(
 max(concatefield) FOR sequence IN ([1],[2],[3])
) AS PVT

---

Regards, RSingh