Hi all,
       here i have a requirement to insert CSVs to a table which has 4 Parameters.
The values are as given below
Parameter1
'06276100011,06276100012,06276100013'
Parameter2
'20061003,20061004,20061005'
Parameter3
'CSUCH,CSUCH,CSUCH'
Parameter4
'373944015,395468826,397600221'

But i want this columns should be inserted in to a single table, say Table1 and the output should look like this(Select * from Table1),

DocID RecDate Verifier MemID
--------------------------------------------------------------
06276100011 20061003 CSUCH 373944015
06276100012 20061004 CSUCH 395468826
06276100013 20061005 CSUCH 397600221

Thanks in advance...



praveen KN

__________________
praveen KN

You say "Paremater"... is this data being passed in from a GUI in the form of 4 separate parameter blocks as your post seems to indicate? If so, what is the maximum/minimum number of CSV's per parameter? Will it always be 3 as in your example? Or, is this data coming in from a file? If it's coming from a file, please post a dozen lines of data from the file

--Jeff Moden

Hi,
   Yes, Data is coming in from a file. Actually i have only this much data as of now in the file. But all columns are of fixed length.

praveen KN

Like I said, please post a dozen rows of the file as they are in the file so we can help... thanks.

--Jeff Moden