pivot in sql server

Jul 25 2016 3:40 AM

I have a salary table like:-<div><table border="0" cellspacing="2" cellpadding="2" width="500"><tbody><tr><td colspan="1"> EmpCode   </td><td rowspan="1"> month</td><td rowspan="1"> salary</td></tr><tr><td> 1   </td><td> Feb2015</td><td> 32000</td></tr><tr><td> 1</td><td> march2015</td><td> 32000</td></tr></tbody><tbody><tr><td> 2</td><td> Feb2015   </td><td> 41000</td></tr></tbody><tbody><tr><td> 3</td><td> feb2015</td><td> 30000</td></tr></tbody><tbody><tr><td> 3</td><td> march2015</td><td> 30000</td></tr></tbody><tbody><tr><td> </td><td> </td><td> </td></tr></tbody></table></div><div> </div><div>i want result set like:-</div><div><table border="0" cellspacing="2" cellpadding="2" width="500" tagtype="InsertTable"><tbody><tr><td> EmpCode</td><td> Jan2015</td><td> Feb2015</td><td> March2015</td></tr><tr><td> 1</td><td> null   </td><td> 32000</td><td> march2015</td></tr><tr><td> 2</td><td> null</td><td> 41000</td><td> null</td></tr></tbody><tbody><tr><td> 3</td><td> null</td><td> 30000</td><td> 30000</td></tr></tbody></table></div><div> </div><div> </div><div> </div>

Answers (1)

access data from form1 to form2 in C#

how to convert .html file to excel in C# windows app