Cacher is the code snippet organizer for pro developers

SELECT TOP (1000) 

      dv.[Value]
      ,[Description]
	  ,CONVERT(INT, av.[ValueAsNumeric]) as [Points]

  FROM [RockRMS-Spark].[dbo].[DefinedValue] dv
  INNER JOIN [AttributeValue] av ON av.[EntityId] = dv.[Id] AND av.[AttributeId] = 3599
  WHERE [DefinedTypeId] = 74
  ORDER BY [Points] desc