SELECT [contract_number] ,[From_Dollar] ,[To_Dollar] ,[Base_Discount_Percent] ,[Start_Date] ,[End_Date] ,[Sum_Of_Sales_Current] ,CASE WHEN ISNULL(base_Discount_Percent,0) = '' THEN 'no data' WHEN ISNULL(Sum_Of_Sales_Current, 0) < From_Dollar THEN 'BELOW RANGE' WHEN ISNULL(Sum_Of_Sales_Current, 0) > To_Dollar THEN 'ABOVE RANGE' ELSE 'BETWEEN RANGE' END AS RANGE_SCORE, CASE WHEN Base_Discount_Percent IS NULL THEN ''--'NONE STATED' WHEN End_Date <= CAST(GETDATE() AS DATE) THEN 'OUT OF DATE' WHEN ISNULL(Sum_Of_Sales_Current, 0) < From_Dollar THEN '0' ELSE Convert(nvarchar(50),Base_Discount_Percent) END AS QUALIFICATION_PERCENT FROM [program].[dbo].[TIER_CAT]
Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.
”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.