Need help on stock export

• dyckwalter

  SSC Enthusiast

  Points: 184

  More actions

  October 19, 2005 at 3:25 am

  #89693

  Hello everyone

  I have the following.

  Have a table Item_Inbound containing

  Item_Code, Units, Sub_Units, Status

  Need to create a new table ExportStock containing

  Item_Code, StockFree, StockBlocked

  Example

  Item_Inbound

  Item_Code       Units      Sub_Units      Status

  A1200              100           10               1

  A1200               50            10               1

  A1200              100            10               2

  B1300               80             20               1

  C1400               60             12               2

  The table ExportStock should like

  Item_Code        StockFree           StockBlocked

  A1200                1500                      1000

  B1300                 1600                          0

  C1400                     0                         720

  I'm looking for a one stop solution to get from one table to the other...

  Can someone help me???

  Thanks

  Walter

• Chris Hedgate

  One Orange Chip

  Points: 25041

  More actions

  October 19, 2005 at 5:50 am

  #598185

  (Saving the Site Owners from some hard work)

  Answered in other thread

  --
  Chris Hedgate http://www.hedgate.net/
  Contributor to the Best of SQL Server Central volumes
  Articles: http://www.sqlservercentral.com/columnists/chedgate/