Y.B. (11/15/2016)

---

Awesome! I...

Thank you,...

Y.B. (11/15/2016)

---

My wife and I decided to check out some Mayan ruins near one of our ports of call during our cruise. I wasn't sure what to expect other...

Here's an option using a modified version of the pattern splitter explained in here: http://www.sqlservercentral.com/articles/String+Manipulation/94365/

The only modification was to make it CASE sensitive.

ALTER FUNCTION [dbo].[PatternSplitCM](@List [varchar](8000) = NULL, @Pattern [varchar](50))

RETURNS...

Yes, AdventureWorksDW (with whatever version number) is the data warehouse...

Eirikur Eiriksson (11/15/2016)

---

lady.konvicka (11/15/2016)

---

hi i have this test code which replace our problem on production

first replace for CHAR(0) removes character 'C' --- I dont know Why

when u set input to...

Cheese

The answer is correct but the explanation seems to be missing the part where it explains why is the second NULL not counted as duplicate. Or maybe it's just me...

J Livingston SQL (11/14/2016)

---

sqlfriends (11/14/2016)

---

Yes , that was posted by me.

But I donot like to use recursive CTE, it is slow.

And I wonder if there are any other...

Eirikur Eiriksson (11/14/2016)

---

Can you post the actual execution plan, would make this a lot easier.

😎

If the plan contains sensitive data then you can use SQL Sentry Plan Explorer to anonymize...

What about rewriting the WHERE clause to this?

WHERE NOT EXISTS(

SELECT 1

...

goodwill

Only MERGE wasn't available in...

Here's an alternative, if the digits don't have to be consecutive. A change to make them only xxxxxxy / yxxxxxx should be easy.

WITH CT(CN) AS (SELECT CN FROM (VALUES (0),(1),(2),(3),(4),(5),(6),(7),(8),(9))...

So, you'll be asking MS for the source code for DTExec? That's the compiled executable needed.