Grand Total

• jsshivalik

  SSChasing Mays

  Points: 612

  More actions

  May 17, 2020 at 7:23 am

  #3752292

  Hi

  I have below code and i want to display Grand Total of Quantity , BaseAmt at the end.

  SELECT

  CASE WHEN RR = 1 THEN CAST(DEntry AS varchar(20)) ELSE '' END,

  CASE WHEN RR = 1 THEN CAST(DocNum AS varchar(20)) ELSE '' END 'Inv. No',

  CASE WHEN RR = 1 THEN DocDate ELSE null END 'Doc. Date',

  Quantity,BaseAmt

  FROM

  (SELECT

  (ROW_NUMBER() OVER(PARTITION BY DEntry ORDER BY DEntry)) [RR], *

  FROM #Tmp0) SUBQUERY1

  Thanks

• frederico_fonseca

  SSCoach

  Points: 16166

  More actions

  May 17, 2020 at 5:23 pm

  #3752333

  what is the final purpose of this SQL - how is it going to be used and where is the final output? e.g. csv file, excel, web page?

   

• May 17, 2020 at 7:11 pm

  This was removed by the editor as SPAM

• drew.allen

  SSC Guru

  Points: 76996

  More actions

  May 18, 2020 at 1:46 pm

  #3752509

  This sounds like something that should be done in the presentation layer, not the data layer.  This is easy in SSRS, for example.

  Drew

  J. Drew Allen
  Business Intelligence Analyst
  Philadelphia, PA