Yup you missed mentioning that. 🙂

As long as it works...

I understand you already have a solution but this might be a bit more efficient. The technique is based on an article by Jeff Moden on Grouping Islands of...

llcooldre75 (1/15/2013)

---

Here is the structure of my tables i am using.

CREATE TABLE Billing (

CUSTCODE VARCHAR,

SALESID ...

wolfkillj (1/15/2013)

---

Actually, that article was my starting point in challenging myself to come up with a true set-based DLD solution. The code posted there is functional but requires a lot...

I don't really know if this applies but if you're creating procedure main_p so that you have a cover SP that you can run by SQL agent (on a schedule),...

Are you sure that link gives you what you need? I looked and it didn't look like the same problem.

This should work as long as the leftmost characters in...

Another cool thing about extended properties is that, when you add them (for example) to a table or to a column, when you use SSMS to script that table's creation,...

Happy to be of service my friend.

Greg Snidow (1/15/2013)

---

Yep, mine is to always keep things as separate...

wolfkillj (1/15/2013)

---

I've been working on a set-based T-SQL solution to determine the Damerau-Levenshtein Distance between two strings. (DLD distance is just like LD - the number of changes required to...

Chances are pretty good that you either haven't...

If we're reviving old, dead threads then I say there's always this:

DECLARE @num BIGINT = 1234567890

,@numstr VARCHAR(20) = ''

;WITH Tally (n) AS (

...

Koen Verbeeck (1/15/2013)

---

I think you can use the 2010 ACE OLE DB driver to read from 2007 workbooks. It's possible you'd have to change the Excel version in the connection...

Koen Verbeeck (1/15/2013)

---

You can install...

oliver.morris (1/15/2013)

---

I see what you are up to here. This is a really neat method and will work it up. Thank you for sending over the CLR reference, I will...