|
|
-
poratips Commented 3 Years ago through Ask
<p>Thanks.</p>
<p>I have same code running on different tables, all the columns and code are similiar just table name different on same DB.</p>
<p>But its not locking on other table, just locking on one perticular table.</p>
<p>Any idea, what's the p...
|
-
poratips Question Asked 3 Years ago through ASK
<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...
|
ask
98
·
2% ·
538
|
|
-
poratips Posted 3 Years ago through Ask
Hi,I am running Store Procedure in sql server 2005 but sometimes i see deadlock error.Could you please advice me what could be the problem and where i need to identifiy?I am doing insert/update inside the procedure.Please see the Store Procedure:
SET A...
|
-
poratips Commented 3 Years ago through Ask
<p> </p>
<p>Hi Madhvinan,</p>
<p>Thanks for oyur help so far, if you see my question that after replacing my actual column, i am getting error.</p>
<p>Please help me if you have time.</p>
<p> </p>
<p>Thanks</p>...
|
-
poratips Commented 3 Years ago through Ask
<p>Madhivanan,</p>
<p>Thanks once again for your great prompt response.</p>
<p>I have to update my column accordingly your solution so i have all the dates in one format like you have showed in your example as above- 11/10/2009 10:18:34 AM Date format...
|
-
poratips Commented 3 Years ago through Ask
<p>Thanks Madhivanan.</p>
<p>Please see the following Table script:</p>
<p><pre></p>
<p>CREATE TABLE [SSTrackTime](<br /> [STrackID] [int] NOT NULL,<br /> [Start] [nvarchar](50) NULL,<br /> [Stop] [n...
|
-
poratips Commented 3 Years ago through Ask
<p>Thanks so much Madhivanan.</p>
<p> </p>
<p> </p>...
|
-
poratips Commented 3 Years ago through Ask
<p>Sorry Madhivanan!</p>
<p>Error was:</p>
<p><span style="font-size: xx-small;">
<p>Msg 242, Level 16, State 3, Line 1</p>
<p>The conversion of a char data type to a datetime data type resulted in an out-of-range datetime value.</p>
</span></p>...
|
-
poratips Commented 3 Years ago through Ask
<p>Thanks Madhivanan!</p>
<p>When i copy your sql as it is and its running very fine but I am also getting an error when i add the records like in this format - <span style="color: #1f497d;">9/4/2008 9:00:01 AM.</span></p>
<p><span style="color: #1f49...
|
-
poratips Commented 3 Years ago through Ask
<p>Sorry, i was trying to format but it didn't.</p>...
|