Im working with SQL Server 2008 I want to get the row wise total for the table and want to merge the 2 string column names for the total column. I have below table data
<HTML>
<Table>
<tr>
<Td>Region</Td>
<Td>Test </Td>
<Td>taken </Td>
<Td>Nottaken</Td>
</tr>
<tr>
<td>India</td>
<td>AA</td>
<td>1</td>
<td>0</td>
</tr>
<tr>
<td>UK</td>
<td>AS</td>
<td>3</td>
<td>4</td>
</tr>
<tr>
<td>US</td>
<td>AF</td>
<td>1</td>
<td>1</td>
</tr>
</Table>
</HTML>
I want the result set like below
<HTML>
<Table>
<tr>
<Td>Region</Td>
<Td>Test </Td>
<Td>taken </Td>
<Td>Nottaken</Td>
<td>Total</td>
</tr>
<tr>
<td>India</td>
<td>AA</td>
<td>1</td>
<td>0</td>
<td>1</td>
</tr>
<tr>
<td>UK</td>
<td>AS</td>
<td>3</td>
<td>4</td>
<td>7</td>
</tr>
<tr>
<td>US</td>
<td>AF</td>
<td>1</td>
<td>1</td>
<td>2</td>
</tr>
<tr>
<td>region</td>
<td>total</td>
<td>5</td>
<td>5</td>
<td>10</td>
</tr>
</Table>
</HTML>
how to write query?
Aucun commentaire:
Enregistrer un commentaire