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.

Why are you explicitly calling that particular column? Also, you really should explicitly define the columns you want returned even if you want all of them returned.

Tried something similiar in a Sandbox database. Under compatibility mode 80, query would work. Under compatibility mode 90, I got the error you did.

Something is different, you just...

What versions of SQL Server? What compatibility mode on the databases?

I see the problem:

select INSPTYPE,* -- right here. You are specifying INSPTYPE explicitly and it is also included in the *, so it is here twice.

from APINSP

where insptype...

What are the table definitions between the two environments? Also, are there any differences between how the two systems are set up? Different collations, something?