1

In the following query, I'm trying to return the data with 2 decimal places (.00) for the SUM line:

SELECT
  CONVERT(varchar, YEAR(COALESCE(release_date, requested_date)))
  + RIGHT('00' + CONVERT(varchar, MONTH(COALESCE(release_date, requested_date))), 2) AS yrmnth,
  salesrep,
  customer_name,
  SUM(price_per_ea * COALESCE(open_release_qty, open_order_qty)) AS ext_price
Clément Prévost
  • 8,000
  • 2
  • 36
  • 51
SoTech
  • 41
  • 1
  • 7

2 Answers2

2

you could use convert for take control over the format 

SELECT
CONVERT(VARCHAR, YEAR(COALESCE(release_date, requested_date))) 
    + RIGHT('00' + CONVERT(VARCHAR, 
 MONTH(COALESCE(release_date, requested_date))),2) as yrmnth
,salesrep
,customer_name
,  Convert(decimal(12,2), 
     SUM(price_per_ea * COALESCE(open_release_qty, open_order_qty)))  as ext_price
ScaisEdge
  • 131,976
  • 10
  • 91
  • 107
1

Use the round function in your select:

round(SUM(price_per_ea * COALESCE(open_release_qty, open_order_qty)),2)
gbeaven
  • 1,522
  • 2
  • 20
  • 40