pivot table example in SQL Server 2005

gistfile1.sql

select 	PT.FacID, f1.FacName, [1] as QtyAlloc, [-1] as QtyUsed, [1] + [-1] as QtyRemain
from
(
		select 	f1.FacID, sign(f1.Quantity) as Sgn, f1.Quantity
		from 	FacCredits f1
) as q1
pivot
(
		sum(q1.Quantity)
		for q1.Sgn in ([1], [-1])
) as PT
left join Facilitators f1 on PT.FacID = f1.FacID
order by [1] + [-1] desc