select
	base.DatabaseName,
	base.ObjectName,
	base.IndexName,
	base.PartitionNumber,
	[REBUILD],[REORGANZE]
from (
				select
					DatabaseName,
					ObjectName,
					IndexName,
					PartitionNumber,
					MaintenanceType = opType,
					MaintenanceDurationMS = cast(datediff(millisecond,DateTimeStart,DateTimeEnd) as decimal(20,4))
				from Stage.[IndexDefragLog]
	) base
pivot (
		avg(MaintenanceDurationMS)
		for MaintenanceType in ([REBUILD],[REORGANZE])
	  ) pvt

SELECT
  databasename,
  objectname,
  indexname,
  partitionnumber,
  rebuildops           = MAX(CASE maintenancetype WHEN 'rebuild' THEN dayssincelastmaintop END),
  reorgops             = MAX(CASE maintenancetype WHEN 'reorg'   THEN dayssincelastmaintop END),
  dayssincelastrebuild = MAX(CASE maintenancetype WHEN 'rebuild' THEN totalmaintops        END),
  dayssincelastreorg   = MAX(CASE maintenancetype WHEN 'reorg'   THEN totalmaintops        END),
  avgrebuildduration   = MAX(CASE maintenancetype WHEN 'rebuild' THEN avgmaintduration     END),

CREATE TABLE #MyTestFormatMessage
(
	ID INT NOT NULL
		PRIMARY KEY CLUSTERED
		IDENTITY(1,1)
	, IDPadded AS (FORMATMESSAGE('%010i',ID))
	, SomeData VARCHAR(1000)
);
CREATE TABLE #MyTestFormatMessage1
(
	ID INT NOT NULL
		PRIMARY KEY CLUSTERED
		IDENTITY(1,1)
	, IDPadded AS (FORMATMESSAGE('%010i',ID))
	, SomeData VARCHAR(1000)
);
GO
INSERT INTO #MyTestFormatMessage1 (SomeData) VALUES ('test1');
INSERT INTO #MyTestFormatMessage (SomeData) VALUES ('test2');
GO

DECLARE @cmd VARCHAR(100) = 'SELECT * FROM #MyTestFormatMessage1'