Viewing 15 posts - 46 through 60 (of 621 total)
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
nums(n) AS...
Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.
January 11, 2013 at 2:50 pm
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...
Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.
January 11, 2013 at 2:22 pm
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...
Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.
January 11, 2013 at 1:04 pm
scotdg (1/11/2013)
Honestly I won't comment on the rest of your post because you come across as extremely arrogant even to go as far as correcting my typos
You hit the nail...
Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.
January 11, 2013 at 10:50 am
AndrewSQLDBA
I ran across this bunch of crap written by a DB2 programmer, trying to write SQL Server code. He does not understand SLQ Server at all
Andrew, I often have to...
Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.
January 11, 2013 at 8:40 am
opc.three
The C# code I provided does exactly that
Ah, my bad then. I'm C# illiterate (and all flavors of C for that matter). Now that you pointed that out,...
Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.
January 11, 2013 at 7:42 am
Alan.B
(just for fun because it's something I've never seen done
Here, here brother. That's what its all about. Well, a lot of it anyway.
Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.
January 10, 2013 at 3:26 pm
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...
Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.
January 10, 2013 at 3:01 pm
Philip-1144230 (1/10/2013)the other two would require me to manually go through roughly 12000 excel files with a average of 15 worksheets each to extract the hyperlinks
Philip, it sounds like you...
Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.
January 10, 2013 at 9:19 am
ravi@sql (1/9/2013)I'll get sucess message but all data will not get copy to excel sheet .
Ravi, when you say "all data will not get copy", do you mean the rows...
Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.
January 10, 2013 at 9:03 am
DevSteve (1/10/2013)
When I tried your method I got an error. I realize I'm using...
Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.
January 10, 2013 at 7:37 am
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,...
Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.
January 9, 2013 at 3:39 pm
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...
Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.
January 4, 2013 at 3:09 pm
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....
Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.
January 4, 2013 at 2:24 pm
Lowell (1/4/2013)
from that you change your query to select from that table, and join...
Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.
January 4, 2013 at 2:18 pm
Viewing 15 posts - 46 through 60 (of 621 total)