THEN 'ALTER TABLE ' + OBJECT_SCHEMA_NAME(pstats.object_id) + '.' + OBJECT_NAME(pstats.object_id) + ' REBUILD PARTITION = ' + CONVERT(VARCHAR(5), pstats.partition ...
,MAX(poh.TotalDue) OVER(PARTITION BY [poh].[ShipMethodID]) AS [MaxTotal] ,COUNT(poh.TotalDue) OVER(PARTITION BY [poh].[ShipMethodID]) AS [CountTotal] ,AVG(poh ...