Click here to Skip to main content
15,918,685 members
Home / Discussions / Database
   

Database

 
QuestionFOR XML Path is giving error [modified] Pin
indian14329-Jun-10 13:55
indian14329-Jun-10 13:55 
AnswerRe: FOR XML Path is giving error Pin
Md. Marufuzzaman29-Jun-10 20:15
professionalMd. Marufuzzaman29-Jun-10 20:15 
QuestionRe: FOR XML Path is giving error Pin
i.j.russell29-Jun-10 23:06
i.j.russell29-Jun-10 23:06 
AnswerRe: FOR XML Path is giving error Pin
indian14330-Jun-10 7:34
indian14330-Jun-10 7:34 
GeneralRe: FOR XML Path is giving error Pin
i.j.russell30-Jun-10 10:39
i.j.russell30-Jun-10 10:39 
QuestionUnable to Connect to Sybase DB in Word 2007 Pin
MWRivera29-Jun-10 11:10
MWRivera29-Jun-10 11:10 
Questionsql functon Pin
Thanusree Duth29-Jun-10 0:01
Thanusree Duth29-Jun-10 0:01 
AnswerRe: sql functon PinPopular
Mycroft Holmes29-Jun-10 3:07
professionalMycroft Holmes29-Jun-10 3:07 
So you have made the most basic error in data storage, you have stored your dates as varchar. You will have trouble until you reformat your data to datetime. Do it NOW!

However this may work on those formats


Select *
From Table1
Order by convert(datetime,StupidVarcharDateField)

Never underestimate the power of human stupidity
RAH

GeneralRe: sql functon Pin
Chris Meech29-Jun-10 6:56
Chris Meech29-Jun-10 6:56 
GeneralRe: sql functon Pin
Mycroft Holmes29-Jun-10 12:57
professionalMycroft Holmes29-Jun-10 12:57 
AnswerRe: sql functon Pin
Md. Marufuzzaman29-Jun-10 4:54
professionalMd. Marufuzzaman29-Jun-10 4:54 
Questiongroup by value in the prefix of the values of that group [modified] Pin
indian14328-Jun-10 9:38
indian14328-Jun-10 9:38 
AnswerRe: group by value in the prefix of the values of that group Pin
i.j.russell28-Jun-10 11:02
i.j.russell28-Jun-10 11:02 
GeneralRe: group by value in the prefix of the values of that group Pin
indian14328-Jun-10 11:14
indian14328-Jun-10 11:14 
AnswerRe: group by value in the prefix of the values of that group Pin
i.j.russell28-Jun-10 20:37
i.j.russell28-Jun-10 20:37 
GeneralRe: group by value in the prefix of the values of that group Pin
indian14329-Jun-10 6:44
indian14329-Jun-10 6:44 
GeneralRe: group by value in the prefix of the values of that group Pin
i.j.russell29-Jun-10 11:26
i.j.russell29-Jun-10 11:26 
GeneralRe: group by value in the prefix of the values of that group Pin
indian14329-Jun-10 12:57
indian14329-Jun-10 12:57 
GeneralRe: group by value in the prefix of the values of that group Pin
i.j.russell29-Jun-10 21:38
i.j.russell29-Jun-10 21:38 
GeneralRe: group by value in the prefix of the values of that group Pin
indian14328-Jun-10 11:51
indian14328-Jun-10 11:51 
RantRe: group by value in the prefix of the values of that group Pin
i.j.russell28-Jun-10 20:44
i.j.russell28-Jun-10 20:44 
GeneralRe: group by value in the prefix of the values of that group Pin
indian14328-Jun-10 20:49
indian14328-Jun-10 20:49 
QuestionUsing dynamic SQL Pin
mjackson1128-Jun-10 5:25
mjackson1128-Jun-10 5:25 
AnswerRe: Using dynamic SQL Pin
David Mujica28-Jun-10 6:05
David Mujica28-Jun-10 6:05 
AnswerRe: Using dynamic SQL Pin
PIEBALDconsult29-Jun-10 18:29
mvePIEBALDconsult29-Jun-10 18:29 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.