Alan.B

I came up with this:

-- strings to compare

DECLARE@s1 varchar(8000)='diner',

@s2 varchar(8000)='dinerr';

DECLARE @Ld int=ABS(LEN(@s1)-LEN(@s2));

IF ((@s1=@s2) OR ((ISNULL(LEN(@s1)*LEN(@s2),0)=0))) BEGIN GOTO LD END;

DECLARE@minlen int=CASE WHEN LEN(@s1)>LEN(@s2) THEN LEN(@s2) ELSE LEN(@s1) END;

;WITH...

dwain.c

I for one have never heard of this famous "Levenshtein Edit Distance" problem, but you can rest assured that now I'm going to have to take a look at it...

Sridhar, maybe something like this will work for you. I think the desired output you posted does not match the data you provided, because it looks like, according to...

You hit the nail...

Andrew, I often have to...

Ah, my bad then. I'm C# illiterate (and all flavors of C for that matter). Now that you pointed that out,...

Here, here brother. That's what its all about. Well, a lot of it anyway.

I'm not certain, but I don't think SQL Server cares if you are a domain admin on your network, your network name will still have to be granted a SQL...

Philip, it sounds like you...

Ravi, when you say "all data will not get copy", do you mean the rows...

DevSteve (1/10/2013)

---

Thanks Greg. Peter's solution is working for me, but I appreciate the input.

When I tried your method I got an error. I realize I'm using...

DevSteve, I think Peter's got it wrapped up, but for some unknown reason I saw this as an unpivot problem. I would probably stick with what you already have,...

I would agree with Phil, especially if the data on the spreadsheet comes from manual entry by users. It would be relatively simple to test the datatypes of your...

Sean Lange (1/4/2013)

---

I like the MySQL convention of using double zeroes for months and years, That is 'yyyy-mm-00' for a month within a year and 'yyyy-00-00' for the whole year....

Lowell (1/4/2013)

---

you need a Calendar table of some sort which gives you the arraay of all possible months;

from that you change your query to select from that table, and join...