Database

select <br />
case when status=0 then 'inactive'<br />
 when status=1 then 'active' <br />
end  as [Status]<br />
 from tablename

USE AdventureWorks
GO
SELECT VendorID, [164] AS Emp1, [198] AS Emp2, [223] AS Emp3, [231] AS Emp4, [233] AS Emp5
FROM 
(SELECT PurchaseOrderID, EmployeeID, VendorID
FROM Purchasing.PurchaseOrderHeader) AS p
PIVOT
(
COUNT (PurchaseOrderID)
FOR EmployeeID IN
( [164], [198], [223], [231], [233] )
) AS pvt
ORDER BY VendorID;

select item_code,ITEM_DESCRIPTION,<br />
(select max(t1.dcode) from qcr100 as t1 where t1.item_code=qcr100.item_code) as dcode,<br />
sum(cast(amount as float)) as amount<br />
from qcr100 <br />
group by  item_code,ITEM_DESCRIPTION