Prev: Yellowfin discusses Consolidation and its impact on the Business Intelligence Market
Next: Convert rows to columns
From: agiler on 6 Apr 2008 00:58
help,a regular text file how to sql 2000 table code ?

i have a text file as follow, line with ��|��and {LF},

8|-000000186075919.|+000000000387820.|2008-03-31|20010423|
9|-000000000003919.|-000000000123620.|2008-03-31|20010123|
8|-000000018623419.|+000000000381230.|2008-05-30|20010423|




i want to sign char(1)��year decimal(18,3) , month decimal(18,3), trandate
smalldatetime��update smalldatetime��after to sql table is as follow,


sign year month trandate update
8 -186075919.000 387820.000 3/31/2008 4/23/2001
9 -3919.000 -123620.000 3/31/2008 1/1/2001
8 -18623419.000 387820.000 5/30/2008 4/23/2001



could you help me how write the sql code ?



 | 
Pages: 1
Prev: Yellowfin discusses Consolidation and its impact on the Business Intelligence Market
Next: Convert rows to columns