seems like table has all the records... still this error. I guess it is due to size issue... I was importing from flat file to sql using wizard.. file size...

Oh topic has sql 2006 instead of sql 2005... typo sorry!

Awesome...Thank you.

This works:

declare @temp_table_name varchar(255), @temp_table_name2 varchar(255)

set @temp_table_name = '[staging1]'

set @temp_table_name2 = '[staging2]'

Exec ('SELECT RowNum ,

WholeRow = dbo.fn_true_csv_split(WholeRow,char(9))

INTO ' +...

it works

Jeff,

First of all thank you so much again for assisting me on this. Since we cannot use the UDF in dynamic sql what do you suggest.. CLR might be too...

e

Use the key to join the table to this subquery and delete .... one way to do that

What do you mean by no relationship? Based on which columns are you looking for relationship or no relationship between the tables?

oh no wonder... I was not able to open that post.

I know that Jeff. Thanks for all ur help...hope I am not ruining your weekend.

Jeff Moden (7/25/2009)

---

Also, I don't see a single example of conditional quoting. It would appear to be a stable format as follows...

1st field - never quoted

2nd field - always...

First, some data from your post...

6053339541,"11 LONG CIRCULAR ROAD ,ST,JAMES,",05,this is a sample,"tiger, scott"

__________ ________________________________ __ ________________ ____________

6053339542,"11 LONG CIRCULAR ROAD ,ST,JAMES,",05,this is a sample,"tiger, scott"

__________...

Guys thanks for all the info... definitely helped me to understand few things...

My issue was solved by updating the compatibility level I think..

exec sp_dbcmptlevel 'dbname', 90

As far as number of rows are concerned, most of the files will be small around 100,000 to 200,000 rows with around 10 fields, but small number (1 a day)...