The cursors you write in stored procedures are server side cursors. When you hear about client side cursors, they are talking about the application using a cursor to loop...

TAman (7/23/2009)

---

The result should be 2.

Which ones?: See below

Emp_ID Start_Entry End_Entry ...

There really should have been a third choice: It Depends. It really does, what data type is being converted to what data type?

Okay, half way there. What have you (or your friend) done to try and solve this particular problem?

If it isn't...

mjarsaniya (7/23/2009)

---

Actually I get this problem previous day.

I have seen the LCK_M_IX from profiler and get that it is intent lock but cant get how to resolve that

can I know...

A datetime value is a datetime value. It doesn't care what the regional settings are. You need to concern yourself on that when converting between character and datetime...

Richard McSharry (7/23/2009)

---

"Really, you ask a question expecting an answer and don't even bother to show us anyhting?? " :w00t:

Sorry, but I believe the actual code is irrelevent to the...

For a quick read on why this doesn't happen on SSC, read here.

There are several other threads around that also discuss this issue as well. Most aren't in favor...

Why? Seeks are faster than scans.

Probably unavoidable in a deparment that small. I'd sit down with the DBA and Developer and make sure that they are working closely together to ensure that both know...

No idea. It isn't something I have needed to do and I'm not going to try it here at work even if I do have access to a test...

But if you remove the [] from around the column named [Column Name], the code is unusable. What's the point?

Duplicate post. Please post any responses here.

Actually, I think you want UNPIVOT.