display multiple lines from based on qty

• Dave

  Newbie

  Points: 5

  More actions

  January 12, 2006 at 4:26 pm

  #167122

  Hi all.. I'm trying to figure out a way to show multiple lines with a qty of 1 instead of one line with qty > 1.

  For example:

  SELECT REPLENIS."PRODUCT", REPLENIS."BULKSLOT", REPLENIS."QTY_REQD", REPLENIS."PACKSLIP", REPLENIS."WAREHOUSE"

  FROM REPLENIS 

  ORDER BY

      REPLENIS.BulkSlot

  Data: 1.00034.23, AE23B, 3, 1222, SVW

  Trying to get these results:

  Data:  1.00034.23, AE23B, 1, 1222, SVW

  1.00034.23, AE23B, 1, 1222, SVW

  1.00034.23, AE23B, 1, 1222, SVW

  Any help would be appreciated. Thanks

• Sergiy

  SSC Guru

  Points: 110208

  More actions

  January 12, 2006 at 5:48 pm

  #614516

  SELECT REPLENIS."PRODUCT", REPLENIS."BULKSLOT", 1, REPLENIS."PACKSLIP", REPLENIS."WAREHOUSE"

  FROM REPLENIS 

  INNER JOIN dbo.Nums on REPLENIS."QTY_REQD" <= dbo.Nums.Number

  ORDER BY    REPLENIS.BulkSlot

  dbo.Nums is a table with IDENTITY(1,1) int numbers in coumn Number.

  _____________
  Code for TallyGenerator

• RyanRandall

  SSChampion

  Points: 13623

  More actions

  January 13, 2006 at 7:03 am

  #614619

  I think the '<=' should be a '>=', but Sergiy's solution is a good one.

  Ryan Randall

  Solutions are easy. Understanding the problem, now, that's the hard part.

• Dave

  Newbie

  Points: 5

  More actions

  February 15, 2006 at 4:46 pm

  #621233

  I finally got back to this report.. this will work, thanks for the help folks.