Nice, the death-star-head-butt-of-death.

err, in...

Bruce W Cassidy (2/3/2009)

---

[font="Verdana"]Does that actually work?

I know in Oracle, if you tried to put the filter criteria for the right hand side being empty into the ON clause, it...

Not sure if this will help, but you may be incurring a lock on sys.objects

Can you try a NOLOCK on sys.objects when creating the cursor, using a READ_ONLY cursor or...

Yip, second (or third) the use of joins. The WHERE clause can also be omitted by placing the condition in the join too. May I also suggest catering for presumed...

Jeff Moden (2/2/2009)

---

The real answer to this question should have been "Since data is not guaranteed to be in any order in a table or query result, and ORDER BY...

That's funny, if only I was there! 😀

Weirdo mondo, another example of where money is the root cause of people's problems, comrade.

Jeff Moden (2/2/2009)

---

Max (2/2/2009)

---

Only problem was that the pig didn't last that long - minor omission though, everyone give Jeff...

Probably: --> click here <--

I don't know, it's tough to say what with RBAR holding out.

And in case you're wondering, Grommit was indeed in Star Wars, Episode III, I believe. The story goes that...

Can you recompile the final select statement in the proc, to return only a single column at first and then a second, and so forth, for the troublesome id. That...

put, at the top of the proc:

SET NOCOUNT ON

and at the bottom

SET NOCOUNT OFF

Ooh, I think I'm going to watch this one.

Another strange thought, can you re-index the table and check again?

Is the filename static and if not will you know what it is? Check out string functions in BOL too, there may be some inspiration there.