I wanted to provide an update, I ended up utilizing SSIS and created a webcrawler script, I am checking if date exists in our library of information and if it...

disregard the last question, i have found that they are char(9) and i used replace for that, thank you again!

Thanks, I will see if I can work with that. Your assistance is greatly appreciated. For some reason though I guess I have some spaces that are not...

Currently I am utilizing replace which is quite nasty because I can not make it universal, I am pulling this via a web crawler I created via ssis.

Currently I have not developed the destination table.

I have read the article but none of the solutions resolve when a previous months value is 0, i need to recalculate the rolling average

SELECT t.name,s.*

FROM sys.tables t

CROSS APPLY MASTER..sys_PhysicalIndexStatistics_Wrapper(DB_ID(), object_id, NULL, NULL, NULL) s

WHERE AverageFragmentation > 0

SP to defrag:

ALTER PROCEDURE [dbo].[dba_indexDefrag_sp]

...

thanks that has helped a bit. Still having issue though. The serviceLocation element restates the namespaces and I do not want it to. Any additional assistance?

Current code:

WITH...

AFTER PLAYING AROUND WITH IT FOR A WHILE, THAT SEEMS TO WORK PERFECT. THANKS FOR YOUR ASSISTANCE!