I'd have used sp_WhoisActive (parameter for system transactions = 1). Maybe that can give you another hint.

I never faced that issue so this is more of a shotgun approach...

Is it a 1 off export? Or something that needs to be done regularly?

doug.williams (5/18/2011)

---

Regardless, it looks as if you want to create a list of employees and their managers.

A simple direct way would be like this:

Select E.EmployeeName, (select EmployeeName from employee where...

Still don't need the nolock there. The update is done and you'll be able to read from the table.

Thanks... not to be a smartass or anything but ever since 2005 I've always been told...

Are you talking about index rebuild? If so then yes.

Sean Lange (5/18/2011)

---

Ninja's_RGR'us (5/18/2011)

---

Sean Lange (5/16/2011)

---

Check out this post from Jeff Moden. split function. This will get you started down the right path. This is a really common misconception about...

Then you don't have permissions.

It might also be a case sensitive server and you're getting the case wrong.

PaulB-TheOneAndOnly (5/18/2011)

---

Just building up on previous postings, as a rule of thumbs: never retrive all columns, never retrieve all rows.(*)

(*) As always...

You can reply... just don't quote him and give him more of what he wants!

Just the heads up. NEVER EVER use nolock unless you're prepared to get crap data (not enough or too much of the valid data). Nolock is not a...

matthew.stone (4/1/2011)

---

Thank you, that does provide a good bit of information. I thought a spot on the 2008 build list would show at what point R2 was started. ...

Yes I'll shut up now :hehe:.

Final...

EdVassie (5/18/2011)

---

If you have a SSRS report that has a multi-value parameter and you want to pass the selected values to a stored procedure in the form 'valuea,valueb,valuec' you can...