That is the reason I am gaoing to plant my size elevens in the other DBA's back side.  He never made any backups of the databases. He "ASSUMED" that the...

I dont deserver any of the blame as it is owned by another DBA that as you can see did not do his job. I was trying to help. T

Thanks...

Hardware errors. You look at the file names and the size on the MDF is 0.

Okay I guess the DBA will soon be wlking with a limp, or removing a my size 11 shoe from somehere not so nice.

First, "I" was not the one that did not have any backups!

Second, Not sure what the problem was but it hit three drives on a raid 5 system. We ran...

First, "I" was not the one that did not have any backups!

Second, Not sure what the problem was but it hit three drives on a raid 5 system. We ran...

Boy does this hit home. I have made similar "feature fixes", and that is when I find out if the deodorant was worth the dollar ten or not. 

Thanks. I am trying it as I type.

Not following this:

Hhere is Y2 defined? In the inner join? Write very slowly 2 hours sleep in the last 2 days. (Darn shoulder thats the last time I toose and...

Thanks again. I plan on reviewing some production queries that have had simular performance issues.

Stacey

I see that you used an inner join where I used just a straight join in the first section.

I am a little confused with the derived statement though....

That worked much faster. It is now 4 seconds instead of 24. It seems I need to learn more about derived tables.

I thank you very much.

Thank you I will give it a try.  I have used a trigger before on tables befor just never for procedures. Did not know about the (@@procid)

Thanks again

yes I can modify the procedures. But how?

I like this one Antares686. It is much simpler then what I tried.

Thank you to all that have helped me with this one. As you can tell i have...