How To Use Order By In Pivot Table ?

heed help
i have a PROCEDURE that generate PIVOT table
how to use ORDER BY

in this part
how to do this ?
ORDER BY unit desc, Fname



Code Snippet
SELECT p.ID,p.new_unit,p.mhlka_id,p.mhlka,
p.[1] , p.[2],p.[3], p.[4], p.[5], p.[6], p.[7], p.[8], p.[9], p.[10], p.[11],
p.[12], p.[13], p.[14], p.[15], p.[16], p.[17], p.[18], p.[19], p.[20], p.[21],
p.[22], p.[23], p.[24], p.[25], p.[26], p.[27], p.[28], p.[29], p.[30]
FROM (

SELECT ID,new_unit,mhlka_id,mhlka,
DATEPART(DAY, Date) AS theDay,
ShiftID
FROM v_Employee
WHERE Date >= @BaseDate
AND Date < DATEADD(MONTH, 1, @BaseDate)

ORDER BY unit desc, Fname

) AS y
PIVOT (
min(y.ShiftID) FOR y.theDay IN ([1], [2], [3], [4], [5], [6], [7],[8] , [9], [10], [11],
[12], [13], [14], [15], [16], [17], [18], [19], [20], [21],
[22], [23], [24], [25], [26], [27], [28], [29], [30])
) AS p
END




the all code




DECLARE @Employee TABLE (ID INT, Date SMALLDATETIME, ShiftID TINYINT)





DECLARE @WantedDate SMALLDATETIME, -- Should be a parameter for SP

@BaseDate SMALLDATETIME,

@NumDays TINYINT

SELECT @WantedDate = '20080401', -- User supplied parameter value

@BaseDate = DATEADD(MONTH, DATEDIFF(MONTH, '19000101', @WantedDate), '19000101'),

@NumDays = DATEDIFF(DAY, @BaseDate, DATEADD(MONTH, 1, @BaseDate))

IF @NumDays = 28

BEGIN



SELECT p.ID,

p.[1], p.[2], p.[3], p.[4], p.[5], p.[6], p.[7], p.[8], p.[9], p.[10], p.[11],

p.[12], p.[13], p.[14], p.[15], p.[16], p.[17], p.[18], p.[19], p.[20], p.[21],

p.[22], p.[23], p.[24], p.[25], p.[26], p.[27], p.[28]

FROM (

SELECT ID,

DATEPART(DAY, Date) AS theDay,

ShiftID

FROM v_Employee

WHERE Date >= @BaseDate

AND Date < DATEADD(MONTH, 1, @BaseDate)

) AS y

PIVOT (

COUNT(y.ShiftID) FOR y.theDay IN ([1], [2], [3], [4], [5], [6], [7], [8], [9], [10], [11],

[12], [13], [14], [15], [16], [17], [18], [19], [20], [21],

[22], [23], [24], [25], [26], [27], [28])

) AS p

END

ELSE IF @Numdays = 30

BEGIN



SELECT p.ID,p.new_unit,p.mhlka_id,p.mhlka,

p.[1] , p.[2],p.[3], p.[4], p.[5], p.[6], p.[7], p.[8], p.[9], p.[10], p.[11],

p.[12], p.[13], p.[14], p.[15], p.[16], p.[17], p.[18], p.[19], p.[20], p.[21],

p.[22], p.[23], p.[24], p.[25], p.[26], p.[27], p.[28], p.[29], p.[30]

FROM (



SELECT ID,new_unit,mhlka_id,mhlka,

DATEPART(DAY, Date) AS theDay,

ShiftID

FROM v_Employee

WHERE Date >= @BaseDate

AND Date < DATEADD(MONTH, 1, @BaseDate)

) AS y

PIVOT (

min(y.ShiftID) FOR y.theDay IN ([1], [2], [3], [4], [5], [6], [7],[8] , [9], [10], [11],

[12], [13], [14], [15], [16], [17], [18], [19], [20], [21],

[22], [23], [24], [25], [26], [27], [28], [29], [30])

) AS p

END