<p><span id="_ctl5_ctlTopic_ctlPanelBar_ctlTopicsRepeater__ctl13_lblFullMessage">Hi,<br />I am running Store Procedure in sql server 2005 but sometimes i see deadlock error.<br />Could you please advice me what could be the problem and where i need to iden...

<p>Thanks Madhivanan and Leonid,<br />I completely aggreed with both of you, unforynately we stores as varchar instead of DatTime which I should.<br />And that's gave liberty to my developer and user to store this different format date records.<br />Now, I...

<p>Hi,</p> <p>I would like to convert the date which is is stored in Varchar.</p> <p>Original date format is like: 2008-09-18T15:52:00.000-04:00 and i need to convert like - <strong>01/27/2009 22:32:37.740  (means mm/dd/yyyy and minutes, seconds) Ex...