convert rows to columns using pivot in sql server

http://dba.stackexchange.com/questions/19057/convert-rows-to-columns-using-pivot-in-sql-server-when-columns-are-string-data

empid    wagecode    amount
  1      basic       1000
  1      TA           500
  1      DA           500
  2      Basic       1500
  2      TA           750
  2      DA           750

Desired output:
empid   basic    TA    DA
  1     1000     500   500
  2     1500     750   750

SELECT empid , [Basic], [TA],[DA]
FROM (
SELECT empid, wage, amount
FROM yourtable) up
PIVOT (SUM(amount) FOR wage IN (basic, ta,da)) AS pvt
ORDER BY empid
GO

strTanNo iStatus strUserName
26627621B 11 Kalpana_QA
26627621B 15 pandiaraja_DC
26627621B 5 lakshmi_QA
26627621B 2 pandiaraja_DC

SELECT strTanNo, ISNULL([2],'') 'DFA', ISNULL([3],'') 'DFA', ISNULL([4],'') 'DFA', ISNULL([5],'') 'QA'
FROM (
SELECT strTanNo, iStatus, strUserName
FROM TBL_Strings_Time_Mstr where strTanNo='26627621B') asss
PIVOT (MIN(strUserName) FOR iStatus IN ([2], [3], [4], [5], [11])) AS pvt
ORDER BY strTanNo




SHDocVw.InternetExplorer

SHDocVw.InternetExplorer IE = new SHDocVw.InternetExplorer();
object Empty = String.Empty;
                object URL = "http:59.151.93.237/sipo_EN/search/tabSearch.do?method=init";
                IE.Visible = true;
                IE.Navigate2(ref URL, ref Empty, ref Empty, ref Empty, ref Empty);
                while (IE.Busy == true || IE.ReadyState != tagREADYSTATE.READYSTATE_COMPLETE)
                {
                    System.Threading.Thread.Sleep(5000);
                }
               
                IE.Visible = false;