Click here to Skip to main content
15,882,152 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
Hi guys,


I wrote this stored procedure:

select distinct convert(varchar(10),ut.TrackDate)  as 'UserDate',
 ud.UnitDepartmentName as 'Department'
from EquipmentTracking ut
inner join UnitDepartment ud on ud.UnitDepartmentID = ut.SectionID
order by convert(varchar(10),ut.TrackDate) desc


But still the repeater showing the data in ascending order. i didn't get this,

Plzzz help me, what to do.

Thanks
Posted

1 solution

Here, you cant desc or asc the strings
SQL
select distinct convert(varchar(10),ut.TrackDate)  as 'UserDate',
 ud.UnitDepartmentName as 'Department'
from EquipmentTracking ut
inner join UnitDepartment ud on ud.UnitDepartmentID = ut.SectionID
order by convert(Datetime,ut.TrackDate,103) desc
 
Share this answer
 
v6
Comments
abdul subhan mohammed 5-Feb-14 3:16am    
But, in storedprocedure its working well, but not in repeater??
King Fisher 5-Feb-14 3:42am    
updated
abdul subhan mohammed 5-Feb-14 3:56am    
yes, i have updated ur sol'n, but its remains same, the bootstrap is not allowing it

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

  Print Answers RSS


CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900