Sign In| Join
Get Help:Ask a Question in our Forums|Report a Bug|More Help Resources
All-Star
15575 Points
2702 Posts
Apr 18, 2011 06:00 PM|LINK
Everywhere you have this: CONVERT(VARCHAR(10),EventRptDate, 101),
Replace it with this: DATEADD(dd, DATEDIFF(dd, 0, EventRptDate), 0)
TabAlleman
All-Star
15575 Points
2702 Posts
Re: why wont my order by work when i have group by before it
Apr 18, 2011 06:00 PM|LINK
Everywhere you have this: CONVERT(VARCHAR(10),EventRptDate, 101),
Replace it with this: DATEADD(dd, DATEDIFF(dd, 0, EventRptDate), 0)