Thanks homebrew! I'm still verifying the data. At first glance, in test, it appears to have completed successfully.

Thanks for the guidance!

So is this right?

UPDATE TableB SET TableB.description = TableB.description + '(SELECT t3.description

FROM TableB AS t1 INNER JOIN

...

Right, but how do I do the WHERE clause of that UPDATE statement, so I'm updating the correct row in tableB?

TABLE A

id =100

parentid =

sku = asdf1234

type = product

description = blah blah blah

showitem = yes

id =115

parentid = 100

sku =

type = feature

description = this is the data I want to...

I want to update TableB.description to append the TableA.description

The issue is there isn't a clean Foreign Key. I have to JOIN TableA back onto itself to get the description...

I gave "everyone" fullcontrol and that worked.

Disregard...haven't had my coffee yet...put isnumeric(search_phrase) in the select statement...it works like a champ...thanks a billion!

SSComitted thanks...we're almost there.

That worked. But, I have the added complication of SELECT DISTINCT and it wants me to put isnumeric(search_phrase) in the select statement.

Here's my query...maybe this will...

This thread suggests upgrading to SP2 will resolve this issue:

http://social.msdn.microsoft.com/forums/en-US/sqltools/thread/e7c0e73e-8d4b-4624-a19e-352a69995f9e/

Come to find out we're not running SP2...I'll let you know if that fixes the issue

My database roles list also does not list "SQLAgentUserRole, SQLAgentReaderRole, SQLAgentOperatorRole" as options.

Here are my options in the database roles list: accessadmin, backupoperator, datareader, datawriter, ddadmin, denydatareader, denydatawriter,...

Figured it out...read my *.CSV into a recordset using OPENROWSET

Then I loop through that recordset inserting each row of CSV data along with the 6 other columns of data. ...

Sorry admin...I tried to delete my duplicate posts. But, I got an error. The reason there were duplicate posts is b/c I got an error every time I...