I have a sql server table which has fields like this
productNO, Description, loc_quantity. one product can have multiple locations . Location has multiple columns for different location codes. Like Location_qty_11, Location_qty_40 like that. The table gets populated from other tables which puts null in the loc_qty column if it does not have any product in that location. How can I select from that table which will have only one productNO, and description then qty for all the locations. If it does n't have a qty it will put 0. When I select it always returns multiple rows for the productNO and description column. Please help.
Thanks in advance.
June 16, 2006 1:03 PM
June 20, 2006 1:15 PM