Also, could you also post the deadlock graph?

Oracle outer join?? No join criteria in the from clause, looks like ANSI-89 style joins in use.

Yup, highest losing score of the week and would have beat ANYONE else this week except Ditka.

Jeff Moden (10/3/2016)

---

Seems odd to hear you say that since you voluntarily re-upped for your overseas gig in the past,...

Jeff Moden (10/3/2016)

---

SQLBill (10/3/2016)

---

Basic Problem Solving Skills checklist:

1. post issue on SQL Server Central without examples or all the details

2. if...

Never seen MS SQL Server run a different procedure than the one invoked in an EXEC statement.

Look at the stored procedure you are executing, is it calling any other procedures?...

What ever happened to basic problem solving skills?

Stephanie Giovannini (10/3/2016)

---

There are embedded single quotes and embedded double quotes. Switching the QUOTED_IDENTIFIER setting will fix the single quote issue, but the embedded double quotes will then be just...

Used it years ago when programmatically adding items to an...

Looks like the embedded single quotes is what is killing you. Check the Quoted_Identifiers option and use double quotes around the string.

We aren't the only site getting hit. The following was in the Code Project EMail newsletter I get:

It's been a messy week with the spammers trying to muddy up...

Based on this:

create table #Test

(

ResultValue varchar(30)

)

insert into #Test(ResultValue) values('1.1')

insert into #Test(ResultValue) values('110.1')

insert into #Test(ResultValue) values('90.9')

insert into #Test(ResultValue) values('0.9')

insert into #Test(ResultValue) values('Unable to Calculate')

insert into #Test(ResultValue) values('Unable to Calculate')

insert into #Test(ResultValue)...

Okay, post a question then a few minutes later post an "answer" that they say works and not to post to that thread. Fine, except what was posted doesn't...

Actually, if what you posted above works I wonder about your data....

patla4u (10/3/2016)

---

If I use maxrecursion in query, is this change server level the thesold or database level ?

Can I implement in production ? What is the advantage and disadvange...