Easy enough. Thank you very much.

Thanks for the link. I have the "Rebuild Index" job setup on a maintenance plan, but I still have a lot of fragmented indexs.

That sounds like a plan. I appreciate the guidance. By the way, that is not being lazy it is being smart. Thanks again.

I appreciate the help. I have around 450 indexes that are over 50% fragmented. From what I have read I need to rebuild rather than reorganize. I do not have...

Thanks

How can I modify your script to group or order by TbName?

I knew it was there somewhere. Thanks for pointing the way.

I appreciate it very much.

That worked! I appreciate the help. I also read the forum etiquette document. How do I get my code to a window of its own like you two did? Any...

Nulls are not allowed on any of the columns I am working with in this script.

Sample:

ID UNIT_LABOR UNIT_BURDEN UNIT_SERVICE ...

I appreciate the replies. I am going to roll with it as is.

Thanks

Thank you

That worked. Thank you.

Tried that and tried refreshing the db. Still no luck.

That works. Thanks for the help.