Hi All
I'm trying to make a tab delimited text file out of a query that works fine , but when I go to define columns from the source query on the text file all I get is blank and nothing gets populated, then when I try to go back and define columns again the MMC just crashes.
Can anyone helpme on this?
Here is the query
SELECT FinalItem, t_dsca, t_cuni, t_item, itemgroup, EngStatus,
leadtimecode, t_dten, glacct, t_citg, t_stoc, t_maxs, t_sfst, t_wght,
t_fltm, '' as pur_lt, '' as mfg_lt, t_osys, t_mioq, t_maoq, t_oqmf,
'' as IgnoreOh, '' as ProdCode, '' as MfgLTMethod,
'' as PlpoRpnFlg, '' as ConsPlanXfers, '' as MrpAnalyPer,
'' as WaXferCalcTyp, '' as FkstItem, '' as TranLTCode, '' as OrdPol
, '' as BKConsMPS, '' as ATPShpOfst, '' as ATPPerTChk
, '' as OBKPer, '' as OrdSplt
FROM items
group by FinalItem, t_dsca, t_cuni, t_item, itemgroup, EngStatus,
leadtimecode, t_dten, glacct, t_citg, t_stoc, t_maxs, t_sfst, t_wght,
t_fltm, t_osys, t_mioq, t_maoq, t_oqmf
having right(FinalItem,1)<>'Z'
I'm trying to make a tab delimited text file out of a query that works fine , but when I go to define columns from the source query on the text file all I get is blank and nothing gets populated, then when I try to go back and define columns again the MMC just crashes.
Can anyone helpme on this?
Here is the query
SELECT FinalItem, t_dsca, t_cuni, t_item, itemgroup, EngStatus,
leadtimecode, t_dten, glacct, t_citg, t_stoc, t_maxs, t_sfst, t_wght,
t_fltm, '' as pur_lt, '' as mfg_lt, t_osys, t_mioq, t_maoq, t_oqmf,
'' as IgnoreOh, '' as ProdCode, '' as MfgLTMethod,
'' as PlpoRpnFlg, '' as ConsPlanXfers, '' as MrpAnalyPer,
'' as WaXferCalcTyp, '' as FkstItem, '' as TranLTCode, '' as OrdPol
, '' as BKConsMPS, '' as ATPShpOfst, '' as ATPPerTChk
, '' as OBKPer, '' as OrdSplt
FROM items
group by FinalItem, t_dsca, t_cuni, t_item, itemgroup, EngStatus,
leadtimecode, t_dten, glacct, t_citg, t_stoc, t_maxs, t_sfst, t_wght,
t_fltm, t_osys, t_mioq, t_maoq, t_oqmf
having right(FinalItem,1)<>'Z'