|
-
Dec 12th, 2002, 11:49 AM
#1
Thread Starter
Addicted Member
reading from a table
hi !!
i have a database name as tempdb
in which the data is
TIMESTAMP,Sun,Nov,24,21:15:23,2002
a,b,c,d
e,f,g,h
TIMESTAMP,Sun,Nov,24,21:16:23,2002
i,j,k,l
m,n,o,p
this is a log file generated......and has thousands of records in it.
So i need this data to be inserted in another database
w.r.t the time as it is generated after ONE minute for eg:
a,b,c,d,24Nov,21:15:23
e,f,g,h,24Nov,21:15:23
i,j,k,l,24Nov,21:16:23
m,n,o,p,24Nov,21:15:23
So the problem is how do i Pick the records (Time) from the tempdb and insert into a different Database.
pls help
hope i was clear enough
waitin replies
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|