SQL query to rows to columns <p>I have a table like this</p> <pre><code>CREATE TABLE #CurrencyRate ( [Base] nvarchar(10), [Quote] nvarchar(10), [Amount] nvarchar(10) ) </code></pre> <p>and it has data like this</p> <pre><code>Base Quote Amount --------------------- R1C1 R1C2 R1C3 R2C1 R2C2 R2C3 </code></pre> <p><strong>Note</strong>: <code>R1C1</code> => Row 1, Column 1</p> <p>I want output like </p> <pre><code>Row Column Attribute Value ----------------------------------------- 1 1 Base R1C1 1 2 Quote R1C2 1 3 Amount R1C3 2 1 Quote R2C1 2 2 Amount R2C2 2 3 Base R2C3 </code></pre> <p>Is it possible to get output like this with some SQL?</p> <p>Thanks in advance</p>