Click here to Skip to main content
14,695,406 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
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
   
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
Top Experts
Last 24hrsThis month



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