Have you tried re-registering your spns for the sql boxes?

In addition, have you tried the steps in this article?

http://blogs.msdn.com/b/sql_protocols/archive/2006/12/02/understanding-kerberos-and-ntlm-authentication-in-sql-server-connections.aspx

temisola1 (5/29/2014)

---

Also, I am going to take a class on T-SQL. I was just thinking about doing Oracle as well so that I can put that on my resume to...

Sean Lange (5/29/2014)

---

SQLRNNR (5/29/2014)

---

Sean Lange (5/29/2014)

---

SQLRNNR (5/29/2014)

---

Sean Lange (5/29/2014)

---

+1000 That one drives me nuts!!! (ok I know it is a short...

So you have a 4yr degree and 4 yrs of IT experience at the age of 19?

Here in the states, that would be questioned quite a bit.

Kudos to you if...

Sean Lange (5/29/2014)

---

SQLRNNR (5/29/2014)

---

NOT a fan...

NOT a fan of that format...

I have had to use string splitters to help with removing certain characters from things like phone numbers.

Another common use is to split delimited strings.

Depending on the string there are...

The sample query you provided does nothing of what you describe. How about posting a query that you have been working on to accomplish the business requirements and then...

Sean Lange (5/29/2014)

---

samalex (5/29/2014)

---

Wow, I agree with literally 100% of what you guys have entered, including 'sprocs'. We have a few non-DBA's who use this verbiage, and it always makes...

That in and of itself is a pet peeve. But it is far worse when a DBA...

And burned!!

:hehe:

In addition to what has been said (e.g. nolock, nesting views and procs, poor formatting etc)

I don't like it when stored procedures are called "sprocs"

I don't like calling a server...

Why are you pulling in discharge date if the parameter value is "A"?

Don't you want to pull in where the active field is equal to "A"?

If you have those values assigned to a parameter in a report, you can take that parameter and pass it to a function in the filter of the dataset for...

It depends. What are your business requirements for the code?