This is what I was saying in #2. You aren't fully serializing the collection, just the keys. The values...

michal.lisinski (7/18/2016)

---

But when I duplicate one or more values (eg. 15.45 instead of 12.25), it returns result: 4 (or less).

I built small console app to checked it, works perfectly, so...

-1

Mcin (4/4/2016)

---

It is problematic, because xp_cmdshell has the same security context as SQL Server service account and it's more than necessary to the work.

My first idea to get rid of...

Alan.B (7/13/2016)

---

CELKO (7/13/2016)

---

-1 is a wonderful answer. Mixed systems (those with more than one language embedded in each other) are always inefficient and a nightmare for anyone to read or...

Alan, if it helps, I just posted the full C# file on PasteBin at:

SQLCLR UDF to parse a string into NGrams

Take care,

Solomon...

Alan.B (7/7/2016)

---

Ok Solomon, I tried to figure this out and failed. Forgive my CLR noobness (I create about 1 CLR/year) and I'm sure this is simple but I'm having a...

You are quite welcome. Glad to hear that it is all working. I will try to add a note...

shibbard 51721 (6/28/2016)

---

Thanks very much for your quick response! And your explanation makes sense and with looking closer I can see how that works. However, my deploy failed...

shibbard 51721 (6/28/2016)

---

I am totally excited to find this great series, I need to get up to speed quickly on CLR and the security issues involved and your tutorial is...

I just realized that I never replied to this, and I apologize for that.

Thank you very much for those kind words. I am glad...

Hey Alan. Interesting request. I do have a suggestion for the code, but first I would like to mention that it is probably best to state at the beginning that...

Makes sense. I was just curious.

I go with bigint because getnumsAB (the...

Hey there. Thanks for the shout-out on SQL#[/url] :-). I like the T-SQL approach and have a few notes (just notes, please don't take any of the following as criticism):