Viewing 15 posts - 271 through 285 (of 498 total)
Try
UPDATE foo
SET Field = REPLACE(Field, '"','')
Gary Johnson
Microsoft Natural Language Group
DBA, Sr. DB Engineer
Gary Johnson
Microsoft Natural Language Group
DBA, Sr. DB Engineer
This posting is provided "AS IS" with no warranties, and confers no rights. The opinions expressed in this post are my own and may not reflect that of my employer.
December 18, 2003 at 7:13 pm
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...
Gary Johnson
Microsoft Natural Language Group
DBA, Sr. DB Engineer
This posting is provided "AS IS" with no warranties, and confers no rights. The opinions expressed in this post are my own and may not reflect that of my employer.
December 18, 2003 at 7:09 pm
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...
Gary Johnson
Microsoft Natural Language Group
DBA, Sr. DB Engineer
This posting is provided "AS IS" with no warranties, and confers no rights. The opinions expressed in this post are my own and may not reflect that of my employer.
December 18, 2003 at 6:53 pm
Use the same technique we do when deleting large amounts of data...
DECLARE @NumRows int
, @iErr int
, @PK ...
--...
Gary Johnson
Microsoft Natural Language Group
DBA, Sr. DB Engineer
This posting is provided "AS IS" with no warranties, and confers no rights. The opinions expressed in this post are my own and may not reflect that of my employer.
December 18, 2003 at 6:41 pm
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...
Gary Johnson
Microsoft Natural Language Group
DBA, Sr. DB Engineer
This posting is provided "AS IS" with no warranties, and confers no rights. The opinions expressed in this post are my own and may not reflect that of my employer.
December 18, 2003 at 6:13 pm
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....
Gary Johnson
Microsoft Natural Language Group
DBA, Sr. DB Engineer
This posting is provided "AS IS" with no warranties, and confers no rights. The opinions expressed in this post are my own and may not reflect that of my employer.
December 18, 2003 at 5:07 pm
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...
Gary Johnson
Microsoft Natural Language Group
DBA, Sr. DB Engineer
This posting is provided "AS IS" with no warranties, and confers no rights. The opinions expressed in this post are my own and may not reflect that of my employer.
December 15, 2003 at 3:58 pm
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
...
Gary Johnson
Microsoft Natural Language Group
DBA, Sr. DB Engineer
This posting is provided "AS IS" with no warranties, and confers no rights. The opinions expressed in this post are my own and may not reflect that of my employer.
December 12, 2003 at 5:11 pm
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...
Gary Johnson
Microsoft Natural Language Group
DBA, Sr. DB Engineer
This posting is provided "AS IS" with no warranties, and confers no rights. The opinions expressed in this post are my own and may not reflect that of my employer.
December 12, 2003 at 5:05 pm
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...
Gary Johnson
Microsoft Natural Language Group
DBA, Sr. DB Engineer
This posting is provided "AS IS" with no warranties, and confers no rights. The opinions expressed in this post are my own and may not reflect that of my employer.
December 8, 2003 at 8:49 pm
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...
Gary Johnson
Microsoft Natural Language Group
DBA, Sr. DB Engineer
This posting is provided "AS IS" with no warranties, and confers no rights. The opinions expressed in this post are my own and may not reflect that of my employer.
December 8, 2003 at 8:27 pm
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...
Gary Johnson
Microsoft Natural Language Group
DBA, Sr. DB Engineer
This posting is provided "AS IS" with no warranties, and confers no rights. The opinions expressed in this post are my own and may not reflect that of my employer.
December 8, 2003 at 7:41 pm
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...
Gary Johnson
Microsoft Natural Language Group
DBA, Sr. DB Engineer
This posting is provided "AS IS" with no warranties, and confers no rights. The opinions expressed in this post are my own and may not reflect that of my employer.
December 8, 2003 at 7:29 pm
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...
Gary Johnson
Microsoft Natural Language Group
DBA, Sr. DB Engineer
This posting is provided "AS IS" with no warranties, and confers no rights. The opinions expressed in this post are my own and may not reflect that of my employer.
December 8, 2003 at 7:20 pm
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...
Gary Johnson
Microsoft Natural Language Group
DBA, Sr. DB Engineer
This posting is provided "AS IS" with no warranties, and confers no rights. The opinions expressed in this post are my own and may not reflect that of my employer.
December 8, 2003 at 7:04 pm
Viewing 15 posts - 271 through 285 (of 498 total)