Query

• jagjitsingh

  Ten Centuries

  Points: 1059

  More actions

  November 13, 2017 at 5:45 am

  #333638

  Hi
    I have  query which returns Location , Vendor , Amount. Query is grouped by Location & Vendor Suppose 3 records are returned . But further i want to display the details of these 3 records from the table . Here Amount is consolidated . Only 1 table is used. 
  I want external query should display all the records of that Location & Vendor record wise which have been returned by internal query

    Location        Vendor              Amount
     A                   X                        10000
     B                   Y                         20000
     C                   Z                         30000

• Thom A

  SSC Guru

  Points: 99133

  More actions

  November 13, 2017 at 5:56 am

  #1967756

  Hi jagjitsingh,

  I don't mean to be rude, but you've been asked and shown enough times to post your questions properly (with DDL, Consumable Sample Data, Expected results, etc). Could you perhaps, do so please?

  Thanks.

  Thom~

  Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
  Larnu.uk

• Chris Harshman

  SSC-Forever

  Points: 42192

  More actions

  November 13, 2017 at 10:41 am

  #1967826

  Maybe the ROLLUP operator could help?
  https://technet.microsoft.com/en-us/library/ms189305(v=sql.90).aspx
  You would have to change your GROUP BY to include the additional columns that you want to aggregate at the lower level by.  If there's too many columns to group by, it may make more sense to get the details, then UNION ALL with the summary?  It's difficult to tell without more information as Thom suggested.