How to sort data in descending order

See more:

SQL-Server-2012

I have created below stored procedure to sort data in descending order of enquiry date but the data isn't getting sorted...
Please help me... Thanks in advance

ALTER Procedure [GetEnquiriesForPurchase]
	@PageIndex INT = 1
	,@PageSize INT = 10
	,@RecordCount INT OUTPUT
	--,@IsProcess int
	,@EmpId int=null
as
Begin
	SET NOCOUNT ON;
	SELECT distinct(Enq.EnquiryId) ,
		--ROW_NUMBER() OVER
		DENSE_RANK() OVER
		(
			--PARTITION BY Enq.EnquiryId 
			ORDER BY Enq.EnquiryDate DESC
		)AS RowNumber,
		Enq.enquirydate, emp.FirstName +' '+emp.LastName as EmployeeName
		,emp.Emailid
		,Enq.[Status]
		,Enq.[ActionRequiredBy]
		, Cust.Name
		,Cust.Designation 
		,Enq.Isprocess
		--,PEND.PurchasePersonId
		--,emp.FirstName +' '+emp.LastName as PurchaseHandler
	INTO #Results 
	from Enquiries Enq 
	inner join employees emp on Enq.SalesPersonId=emp.Id 
	--inner join PurchaseEnquiryNewDetails PEND on PEND.PurchasePersonId =emp.Id and PEND.enquiryId=Enq.enquiryId
	inner join Enquirydetails enqdet on enqdet.EnquiryId=enq.EnquiryId
	inner join Customers cust on Enq.CustomerId=Cust.Id and enqdet.manufactureCode in ( select mfg.manufactureCode from manufacturers mfg
			inner join aspnet_Roles asr on asr.RoleName=mfg.Name
			inner join aspnet_UsersInRoles aur on aur.RoleId= asr.RoleId
			inner join employees emp1 on emp1.loginid= aur.UserId and emp1.Id=@EmpId)
	ORDER BY Enq.EnquiryDate DESC

	SELECT @RecordCount = COUNT(*)
	FROM #Results

	SELECT * FROM #Results
	WHERE RowNumber BETWEEN(@PageIndex -1) * @PageSize + 1 AND(((@PageIndex -1) * @PageSize + 1) + @PageSize) - 1

	DROP TABLE #Results
End