SELECT  U_ObjectValue COLLATE SQL_Latin1_General_CP850_CI_AS, -- AttrCode - nvarchar(50)
                        t1.Name COLLATE SQL_Latin1_General_CP850_CI_AS, -- AttrName - nvarchar(250)
                        U_ObjectType COLLATE SQL_Latin1_General_CP850_CI_AS -- AttrNBR - nvarchar(50)
                FROM    Core.TCP_SServiceDB.dbo.DMSViewStockCountingCompetitor t0
				INNER JOIN Core.TCP_SServiceDB.dbo.DMSViewStockCountingItemOfCompetitor t1 ON t1.Code = t0.U_ObjectValue