I am using the following stored proc to insert a bar delimited text file I had thought that it was working fine until I checked the data and found that for some reason only every other line of the text file is inserted. Does anyone have any ideas as to why that might be ? CREATE PROCEDURE importcsv @user_site_id varchar(100), @filename varchar(255), @tablename varchar(25), @template varchar(255) as declare @dynINSERT varchar(300) declare @dynDELETE varchar(300) declare @dynUPDATE varchar(300) select @dynDELETE = ' DELETE FROM '+@tablename select @dynINSERT = ' BULK INSERT '+@tablename+' FROM '''+@filename+''' WITH(TABLOCK , KEEPNULLS , FIELDTERMINATOR = ''|'' , ROWTERMINATOR = ''\n'' , FIRSTROW=2, FORMATFILE='''+@template +''' )' select @dynUPDATE = ' UPDATE '+@tablename+' SET call_site_id = '''+@user_site_id+''' WHERE call_site_id = ''unknown''' exec(@dynDELETE) exec(@dynINSERT) exec(@dynUPDATE) Colin Robinson Senior Analyst Programmer In-tuiton.co.uk +44 1825 746400 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Get the mailserver that powers this list at http://www.coolfusion.com Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
