It was a difficult one, but I hired a consultant to do the legwork, as I couldn't find the time to do it myself

Here's his (working) solution. All credits go...

Thank you, Jeff. I've been away a few days, sorry for the late reply.

Yes, the typo's are my bad. I'll study some more on your explanations.

Sorry to be a bother, but seem to have found an issue with your code.

You state:

WHEN f.HierarchicalPath LIKE '%\'+o.eq_nmr+'\%' THEN 'Circular Cause'

but f references #found with a

WHERE...

Jeff, wonderful post, very helpful.

I'll go study your example code and see what comes up.

Thanks for the reference to hierarchy studies, I'll put it in my reading/todo list.

Tried your code...

I'll look into the FK thingie. Would be nice if you could point me in the right direction to modify my sp to CTE instead of cursors.

How about a join to OUTPUT inserted.* or deleted.* ?

Got the same CPU burn on our x64 2005 Enterprise servers and my 2008 x64 laptop server.

Maybe I'm thinking too simple for this question, but why not use:

select convert(VarChar(32), PURCHASE_DATE, 3)

Hi all,

I tried this:

select *

--into test

from openrowset('msdasql', 'driver={microsoft dbase driver (*.dbf)};dbq=D:\McBAM\BamTst\Data\', 'select * from MT101108')

And got these errors:

OLE DB provider "msdasql" for linked server "(null)" returned message "[Microsoft][ODBC dBase-stuurprogramma]Algemene waarschuwing...

Ok, that's a lot clearer for me then.

How do I check the size before processing?

Is there a way to handle this error in my User defined function, zo that...

vkoka (8/27/2008)

---

Explanation:

Top Most Parent Childs level

OB000274 OB000033...

Thanks, but either I was unclear, or I don't understand the solution. I get :

OB000033 2 OB000274

OB000034 2 OB000274

OB000035 2 OB000274

OB000036 2 OB000274 ...

psmith (8/18/2008)

---

How do you ensure proper productivity and avalability for each employee? Some people have to deal with at home interruptions of various forms effecting their personal efficiency. I see...

My current company, as well as the I'm starting with september 1st, both have adopted teleworking intensively. Both driven by the lack or shortage of office space. I love it!

Cees

Ian Massy

---

If you're going to snoop, think about what you might find and how you would react to it, then think about what would happen if you were caught (either...