Try

UPDATE foo

SET Field = REPLACE(Field, '"','')

Gary Johnson

Microsoft Natural Language Group

DBA, Sr. DB Engineer

I think the problem is that you are using the Like statement on the outer table in the where clause rather than the join clause. This will in effect cause...

I don't believe you will be able to trap the error in TSQL when the file can't be opened. Personally I feel that this should be done the other way...

Use the same technique we do when deleting large amounts of data...

DECLARE @NumRows int

    , @iErr int

    , @PK ...

--...

Better yet just store the scripts as a file WITHOUT the DB Name. Then use a batch file to run the scripts via osql. Since the scripts will be running...

jxflagg is correct. If you create a temp table and then use dynamic sql to fill it you should be able to create a cursor against it with no problems....

Give this a try Bruce,

SELECT fName

FROM Names

WHERE fName COLLATE Latin1_General_BIN LIKE ('[a-z]%')

Basically this is using psuedo regular expressions inside the Like function. I've added the collate...

I've never seen that. But just out of curiosity what happens if you change the query to the following?

 

SELECT X.*

FROM ACCOM_LIVE X 

 ...

If that is the case I would write a batch file to add a "LineNumber" field to your text file and import it as a field in your table. Then...

Andy,

I too wish there were an easier way to do this as my SP that uses the Explicit XML conversion is almost 3000 lines long! Trying to debug it...

I'm afraid that the sp_helpreplicationoption only works on publishers. The only thing I can think of is to check to see if there are any tables in your database that...

Are you stuck with this data model? It would seem much easier if you had a table to hold the case information (tblCase) and just one table to hold the...

I have a UDF that will do the parsing of the string and return a table. I then simply write something like the following.

UPDATE T

SET BTI...

While your resolution may work I would still suggest putting your field names explicitly in the query as was suggested by Chris and Jeremy. You are taking sloppily written bug...

For a left join you could try something like the following...

SELECT T.IDFromTable1 , T.IDFromTable2 

FROM Table T

    LEFT JOIN Table T2 ON T.IDFromTable1...