I don't know how the replace function behaves in different collations, but I know the problem is related with different collations.

Let' see it..

DECLARE @str VARCHAR(100)

SET @str = '1234567890'

SELECT REPLACE( @str,...

Chris Morris (4/8/2009)

---

Ooookaaaaayyyy proof of the pudding...run...

Peso (4/8/2009)

---

Same as before.

And I am little suspicous about your algorithms. For both you and Chris all 6250 records in the final resultset are ordered by original ID.

My suggestion are...

Or this way too...

DECLARE @SomeFile VARCHAR(255)

SET @SomeFile = 'C:\WINDOWS\system32\FileName.xls'

SELECT RIGHT( @SomeFile, CHARINDEX( '\', REVERSE( @SomeFile ) + '\' ) - 1 )

Not that old enough:-D...

I am working on wretched servers with...

236 ms! looks great! Can I...

Fortunately, I had enough time to test for 5000...

Peso,

I think the results of your query seems to be incorrect. Here are the results...

-- Expected Results

idcol1col2col3col4col5col6col7col8

12.353.013.494.254.795.365.826.31

2NULL3.594.32NULL5.21NULLNULL7.12

3NULLNULLNULL5.235.416.336.897.99

4NULL5.315.465.92NULL6.877.34NULL

55.125.666.316.92NULL7.878.34NULL

-- Actual Results

IDcol1col2col3col4col5col6col7col8

12.353.013.494.254.795.365.826.31

2NULL3.594.32NULL5.21NULLNULL7.12

55.125.666.316.92NULL7.878.34NULL

3NULLNULLNULL5.235.416.336.897.99

4NULL5.315.465.92NULL6.877.34NULL

Chris Morris (4/7/2009)

---

Ramesh (4/7/2009)

---

Guys, It looks like an interesting problem for me and I would like to try my hands on it. But the problem is that I still...

Since you are not referring to any outer table columns in your inner table, the optimizer smartly generates an execution plan that reads the inner table only once. That's...

Guys, It looks like an interesting problem for me and I would like to try my hands on it. But the problem is that I still not completely understood...

You are always welcome. And I'm glad that I could help you.

Probably, SSIS' Execute SQL Task enforces the explicit conversion of data types for performance issues. Its fine...

See if these links help you..

http://blogs.conchango.com/jamiethomson/archive/2006/09/12/SSIS_3A00_-Checking-if-a-row-exists-and-if-it-does_2C00_-has-it-changed.aspx

http://www.sqlis.com/post/Get-all-from-Table-A-that-isnt-in-Table-B.aspx

Service Packs are issued against the product and not against the individual services or components within the product. See the below link for all latest builds of all versions...

Does these links help?

http://social.msdn.microsoft.com/forums/en-US/sqlintegrationservices/thread/90eed185-751e-4f36-89b1-35b2224e5819/%5B/url%5D

http://social.msdn.microsoft.com/Forums/en-US/sqlintegrationservices/thread/c131a0a8-ed27-4dbb-9ecc-fbf624b057fb/%5B/url%5D