Use rownumber in a derived table then filter on WHERE RN = 1

And the report runs on it's own???

Never seen that.

GSquared (11/14/2011)

---

Ninja's_RGR'us (11/14/2011)

---

GSquared (11/14/2011)

---

SQLRNNR (11/13/2011)

---

I find the practice of prefixing with tbl_ just a waste of 4 chars in a table name. It would be funny if a proc...

AndrewSQLDBA (11/14/2011)

---

There are other columns involved, and the Distinct has already been used to query the data from the first table into the table variable. Unfortunately, none of the other...

Been there, done that!

Ok, can't help with that.

peterzeke (11/14/2011)

---

Huh... don't recall ever seeing an "in" claused used in a join...

Anything wrong with SELECT DISTINCT ...?

Pardon my french!

Since when can you install 64 bit software on Windows XP 32 bit?

You're blocking could be resolved by better indexing.

Tracewrite, how many traces do you have running at the moment? Server side or GUI?

network, this is the server waiting on the...

and tonight's 100 M lottery numbers are!

:hehe:

GSquared (11/14/2011)

---

SQLRNNR (11/13/2011)

---

I find the practice of prefixing with tbl_ just a waste of 4 chars in a table name. It would be funny if a proc were prefixed...

GilaMonster (11/14/2011)

---

Do note that Lowell's code is a just a snippet, not the full code necessary.

Msg needs to come from the EventData function, it may need some XQuery. In short,...

Please upload it on the thread.

Did you read the ms doc in the links of the script?