My suggestion would be to have a staging table. Do the import in 2 steps,
pull from the CSV into the staging table. Then populate the table via a
query joined to the staging table.

Brian Freeman
(770) 916-0595 ext. 415
Carnegie Technologies/Bluewave Computing
www.carnegie.com and www.bluewave-computing.com

labuk das wrote:
> Hi Friends,
>
> I am using sql 2K on win2k server. I have a table of
> 10 columns, out of which 8 columns to be filled from
> the CSV file and another 2 columns to be filled by a
> query (it has to select value from other table)
>
> I would like to insert each and every record
> simultaneously from csv file and from the query.
>
> Anybody could advise me on this, please.
>
> Thanks in advance.
>
> Regards
> kumar
>
> ________________________________________________________________________
> Missed your favourite TV serial last night? Try the new, Yahoo! TV.
> visit http://in.tv.yahoo.com
>
> ---------------------------------------------------------------------
> TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
> To unsubscribe, e-mail: mssqldba-[Email Address Removed] For additional commands, e-mail: mssqldba-[Email Address Removed]MS Sql Server LazyDBA home page