BTW, I'm linking people to my happy announcements list for the next two weeks.

http://www.absolutewrite.com/forums/showthread.php?t=245248

And... The Hivemind Collective has a website now for the Latchkeys series with links to Kindle &...

I am so tempted to do the Holy Grail joke as a QotD.

Steve, would you approve such an animal if I sent it in?

Steve Jones - SSC Editor (5/18/2012)

---

Gazareth (5/18/2012)

---

I wonder if he could change it to...

SQL Kiwi (5/18/2012)

---

john.p.lantz (5/17/2012)

---

I've got a simple SQL...

select * from table1 a

join table2 bon a.id_rssd =...

I will try the code with the Merge. I've already done the non-Merge method, which required several statements. Maybe Merge can help me compress that a bit.

John,

Your first post indicates that your real code is much more complicated than the code you posted in this thread. Is that true?

If so, can you post the code so...

Eugene, I appreciate what you're saying, but please watch how you word it. Your tone in your last post came across very harsh and .. well, there's another poster on...

That's what I was wondering. Thank you, Gus. You have saved me some head-banging time.

When executing your query in SSMS, go to Query -> Include Actual Execution Plan. Alternately, if you don't want to run the query, you can use Query -> Display Actual...

Books Online has all the details on how to use the transformation tasks that I told you about. If you want to use SSIS, refer to that and the Microsoft...

Drew, how does that prevent NULL from overriding your 0?

If there's no auditing, then the only possible option is to look at Active Directory for those logins that are domain logins. If they're all SQL logins, there is nothing...

Stefan Krzywicki (5/17/2012)

---

GSquared (5/17/2012)

---

Stefan Krzywicki (5/17/2012)

---

Steve Jones - SSC Editor (5/17/2012)

---

Thanks to new data mining abilities I think I read that they have the ability, to 75% or 90% or...

If you want an answer, you should post the name of the solution you found and ask for reviews.

There are several third party tools and not everyone knows them all...

Unless you've been auditing the logins, there's no good way to tell. Nothing in the system, that I am aware of, can give you this information.

Sorry.

EDIT: On the other hand,...