The output will not work since I am deleting the children first and I am not sure if the values will be in that table. Since there are multiple...

Is that not what I pasted in on the post above?

Ninja is right cascade is not an option on self referencing tables

I have to do a join already for the self reference

WITH tree (id) ...

Can't remember the specifics and maybe someone else does. If you take the mdf and reattach it to the 2K engine it should work. Then under option in...

Is the cube partitioned? how many records in the cube? Have you tried to manually refresh the cube?

When you click on the server and change the database settings it does not say you have to restart the service. When I did that and tried to create...

So I ended up running DBCC Checktable and that fixed the select issue. I was still having trouble on the delete. It was the self reference making the...

I am currently running

UPDATE STATISTICS Pieces WITH ROWCOUNT=1000000

Go

Not sure if that will fix this or not. It has been already running for 10 minutes. Which makes me think...

Thanks I appreciate the feedback. We used the isolation on another solution that worked well. We are currently using timestamp all over to make sure we are versioning...

can you do this instead. It would require less i/o then a temp table

--Get all Matching Products

Select ProductName,CategoryName, TheCount

From Product

INNER JOIN

(SELECT CategoryName,count(CategoryName) TheCount

From Products

Where ...

) sub

ON CategoryName =...

I just wanted to say thanks. Once I put this proc into a production setting it was destroyed not only time wise but it locked up. The Team...

Thanks for the advice. Everything I have ever been taught says No to cursors especially two cursors recursively calling themselves. I have to imagine when I put this...

I had delete cascade working before this but they wanted more flexibility. They said if this works it would help in the long run.

you have to think larger scale on this. This is one proc that you can send any table in a relational DB and it deletes all data pertaining to...