Prev: Convert rows to columns
Next: Client side insert update
From: Erland Sommarskog on 5 Apr 2008 18:21
agiler (sulichun(a)tom.com) writes:
> 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 ?

You have already posted this question to
microsoft.public.sqlserver.programming and I have answered the question
there. Please do not move the thread to other groups. Also:

> Date: Sat, 5 Apr 2008 21:58:14 -0700

This date is the future. Please check your computer clock and your
time-zone settings.


--
Erland Sommarskog, SQL Server MVP, esquel(a)sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
 | 
Pages: 1
Prev: Convert rows to columns
Next: Client side insert update