Hi All,
I wants to convert rows to columns. i have the given below
SELECT TOP 100 PERCENT dbo.tblPatient.pat_reg_no, dbo.tblPatient.pat_name, dbo.tblBillNo.bill_no, dbo.tblDetailServices.srv_name,
SUM(dbo.tblPatientBill.pbl_amount * dbo.tblPatientBill.pbl_NoOfTimes) AS nSrvAmount
FROM dbo.tblBillNo INNER JOIN
dbo.tblPatientBill ON dbo.tblBillNo.bill_adm_id = dbo.tblPatientBill.pbl_admission_id INNER JOIN
dbo.tblDetailServices ON dbo.tblPatientBill.pbl_ser_id = dbo.tblDetailServices.srv_id INNER JOIN
dbo.tblAdmission ON dbo.tblBillNo.bill_adm_id = dbo.tblAdmission.adm_id INNER JOIN
dbo.tblPatient ON dbo.tblAdmission.adm_pat_id = dbo.tblPatient.pat_id
WHERE (dbo.tblBillNo.bill_date >= '2006/12/10 14:00') AND (dbo.tblBillNo.bill_date <= '2006/12/11 14:00')
GROUP BY dbo.tblBillNo.bill_no, dbo.tblPatient.pat_reg_no, dbo.tblPatient.pat_name, dbo.tblDetailServices.srv_name
ORDER BY dbo.tblBillNo.bill_no
and the resuls are
pat_reg_no Name Bill Service Amount
29978 Syed Ijaz Hussain 38514 APTT 315
29978 Syed Ijaz Hussain 38514 Blood C/E 275
29978 Syed Ijaz Hussain 38514 Blood Sugar 1300
29978 Syed Ijaz Hussain 38514 BUN 125
29978 Syed Ijaz Hussain 38514 Creatinine 125
29978 Syed Ijaz Hussain 38514 E.C.G. 1800
29978 Syed Ijaz Hussain 38514 Emergency Ward 15000
29978 Syed Ijaz Hussain 38514 Potassium 75
29978 Syed Ijaz Hussain 38514 PT with INR 150
36159 Muhammad Musa Khan 38515 Advance Adjustment. 5000
36159 Muhammad Musa Khan 38515 BUN 125
36159 Muhammad Musa Khan 38515 C.C.U 4000
36159 Muhammad Musa Khan 38515 Cath Lab Charges 7515
36159 Muhammad Musa Khan 38515 Creatinine 125
36159 Muhammad Musa Khan 38515 E.C.G. 300
36159 Muhammad Musa Khan 38515 Hb 50
i wanted to do it like this
MR # Name Bill # APTT Blood C/E BUN
29978 Syed Ijaz Hussain 38514 315 275 0
36159 Muhammad Musa Khan 38515 125
