Goldie Graber (4/8/2009)

---

That won't work, Lynn. It doesn't take into account consecutive blanks.

For example if I use the following data, I still expect 1 as the answer but your query...

Global temporary tables (##temptable) stay around until SQL Server is restarted. Local temporary tables (#temptable) will dropped when the session that creates them ends.

Sounds like the client tools weren't install on the server. Was SQL Server installed as part of the application or separately? I guess what I'm trying to figure...

I would also like to verify what version of SQL Server you are running.

sward (4/8/2009)

---

Thanks for your replies. In answer to your questions see below:

* Are the 4 (source + 3 destinations) same structure?

--The destination tables have the same field names.

* Could you...

Tara (4/8/2009)

---

Ok,i'll put in with some example.

I have tableA with CCode

and would...

You can also check this out:

--- sample table

CREATE TABLE #CheckIn

(

CheckInID INT IDENTITY(1,1)

,UserID INT

,Comment VARCHAR(50)

)

--- insert some sample data

INSERT INTO #CheckIn (UserID, Comment)

SELECT 1, 'A'

UNION ALL...

It isn't REPLACE that is doing this, it is your collation. In a case-insensitive collation 'a' = 'A'. As shown by your own example, in a case-insenstive collation...

Please don't double post. It fragments answers.

Continue replies here.

The issue is due to your using a case insensitive collation. Look at the following:

DECLARE @str VARCHAR(100)

SET @str = '1234567890'

SELECT REPLACE(@str collate Latin1_General_CI_AS,CHAR(179),'_')

SELECT REPLACE(@str collate Latin1_General_CS_AS,CHAR(179),'_')

SELECT REPLACE(@str collate Latin1_General_BIN2,CHAR(179),'_')

Could you successfully move the backup file you created locally to the UNC location?

Luke L (4/8/2009)

---

A few months back Jeff was soliciting feedback for a topic similar to "Why do we need this?" He was attempting to figure out why people kept...

Glad to hear it worked. Just so you know, it is just common curtesy to let people know if your problem has been solved and how. This is...

Lynn Pettis (4/7/2009)

---

I did a little more reading, Jeff....

Curious, you respond to Jerry, but not a word about wether or not my suggested change helped you or not? Sorry, but something is missing there, don't you think?