Why are you re-posting your original post? As I said in my last post it makes absolutely zero difference which column or table is on which side of an equality...

The one you nailed blew me away!!! I was still trying to...

SQLRNNR (6/23/2014)

---

Sean Lange (6/23/2014)

---

sweet. Seems that the two of us have been racing for the last...

sweet. Seems that the two of us have been racing for the last few months. 😛

Hi and welcome to the forums. From your explanation I am almost certain we can do this without a cursor. In order to help we will need a few things:

1....

DKG-967908 (6/23/2014)

---

Sean,

this user probably be a member of multiple groups(domain group) that i will check with windows team.

but how can i check at SQL level that any groups "have deny...

DKG-967908 (6/23/2014)

---

Dear Sean,

thanks for your quick response, after checking a lot on google i asked my question here when i didn't get any appropriate solution.

Please can you help checking ...

What have you tried? A quick google search of your exact error message produces a number of hits. Some of those are even right back to this site and all...

gwyn.jones (6/23/2014)

---

The NOLOCK was drilled into me at my last job by the DBA there. He said it would stop deadlocks given records are constantly updating. It was...

But what is the question? In your original queries the only difference I can see is the order of the...

Eirikur Eiriksson (6/22/2014)

---

Sachin Nandanwar (6/22/2014)

---

Eirikur Eiriksson (6/21/2014)

---

Sachin Nandanwar (6/21/2014)

---

What should happen in case of trailing zero's ? Example 1000,9990 or zero's that are neither leading or trailing ex :...

I'm glad Chris was able to help you out. However, I can't help but notice that you are using NOLOCK. Are you ok with missing and/or duplicate data? Do you...

abhas (6/23/2014)

---

Hi All,

I am having below query which gives me result fine only if i give Y.YEARINFO = 2014(here if i give any year data is coming rite, e.g. 2015,2020...

TheSQLGuru (6/20/2014)

---

Sean Lange (6/20/2014)

---

ngustafson-1056093 (6/20/2014)

---

Well it that makes complete sense! For some reason I did not think I could look at two different columns in a case statement. ...

ngustafson-1056093 (6/20/2014)

---

Well it that makes complete sense! For some reason I did not think I could look at two different columns in a case statement. Thanks so...