/****** Object: View [dbo].[EPOExtendedComputerProperties] Script Date: 6/2/2021 4:44:37 PM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE VIEW [dbo].[EPOExtendedComputerProperties] AS SELECT ParentID , EthernetMacAddress_1, OtherMacAddress_1, OtherMacAddress_2 FROM ( SELECT ParentID, [ColumnName], [PropValue] FROM EPOExtendedComputerPropsVw) X PIVOT ( MIN([PropValue]) FOR [ColumnName] IN (EthernetMacAddress_1, OtherMacAddress_1, OtherMacAddress_2) ) P GO