How to find unique values in a table

• Jonathan AC Roberts

  SSCoach

  Points: 18407

  More actions

  May 6, 2021 at 10:48 pm

  #3880318

  Mond wrote:

  Hello trying to find unique values on the following table

  First temporary table  query (Master Data)

  insert into #tempCOO select sk.CountryOfOrigin,im.partnumber,sk.Quantity,sol.id,lp.id,lpl.id,so.id,p.SerialNumber FROM  sk join  lpl on sk.LoadPlanLineId = lpl.id join  lp on lp.id = lpl.LoadPlanId join  sol(nolock) on sol.id=lpl.SalesOrderLineId join so on so.id=sol.SalesOrderId join im on im.id = sol.itemmasterid join pd on pd.content = sk.batchnumber and Pd.PackageAttributeId=37 join p on p.id=pd.PackageId where lp.Loadnumber= 'L001' order by p.SerialNumber desc

  The result is the following:

  I need to find unique values for a combination of country of Origin and Part Number

  These are the values I expect

  Could you help me to  write the querys I need?

  Thanks so much

  SELECT CountryOfOrigin, 
         PartNumber, 
         SUM(Quantity) Qty,
         'x' Sol,
         'x' LoadPlanId,
         'x' SalesOrder,
         'x' PalletNumber
    FROM #tempCOO
   GROUP BY CountryOfOrigin, PartNumber
   ORDER BY CountryOfOrigin, PartNumber

   

• Mond

  Old Hand

  Points: 356

  More actions

  May 7, 2021 at 1:15 am

  #3880366

  This works super good:

   

  SELECT CountryOfOrigin,

  PartNumber,

  SUM(Quantity) Qty,

  'x' Sol,

  'x' LoadPlanId,

  'x' SalesOrder,

  'x' PalletNumber

  FROM #tempCOO

  GROUP BY CountryOfOrigin, PartNumber

  ORDER BY CountryOfOrigin, PartNumber

   

  thanks a lot!!!!

• Mond

  Old Hand

  Points: 356

  More actions

  May 7, 2021 at 1:15 am

  #3880367

  thank you so much!!