Design approach advice -
07-18-2004
, 03:35 PM
I need to create a text file using information from SQL
that looks something like the following-
Before I go off on goose chase, can anyone recommend an
area/process that I should look into?
01(order_number,6),(Cust_Number,5),(Cust_Name,30),
(orderdate,6),(SHIP_TO1,30),(SHIP_TO2,30),(SHIP_TO 3,30),
(SHIP_TO_CITY,23),(SHIP_TO_ST,2),(SHIP_TO_ZIP,5),
(PO_NUMBER,10)
02(SHIP_VIA,2),(TERMS_CODE,2),(creditcard,16),(cce xpire,4),
(zip,5),(address,5),(WEIGHT,4),(BOXES,4),(TAX_AMT, 9),
(SALE_AMT,9),(Total_Amt,9),
(shiphandling,9), , , , ,
, , , ,(taxcode,1),
(FreightTerms,1)
03(Item_Number,9)0,(Price,8),(Quantity,5) |