NP

This should do the trick:

--Setup

IF OBJECT_ID('tempdb..#t1') IS NOT NULL

DROP TABLE #t1;

IF OBJECT_ID('tempdb..#t2') IS NOT NULL

DROP TABLE #t2;

CREATE TABLE #t1 ([Server] varchar(10) primary key,

[Name] varchar(10) NOT NULL,

...

Jeff Moden (1/10/2013)

---

Alan.B (1/10/2013)

---

This morning before work for example, after a lot of effort, I finally figured out how to get the Levenshtein Edit Distance between 2 strings without a...

Greg Snidow (1/11/2013)

---

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...

soni321 (1/10/2013)

---

yes it is sql server 2012 developer.i have windows7 home premium.Error says i need windows 7 sp1.now my question is i have home preium window 7 i am able...

Based on what you are saying I think you mean SP1 (Service Pack1)... And is this SQL Server 2012 Express?

You may just need to run Service Pack 1.

What...

What's the error?

Sean Lange (1/10/2013)

---

Alan.B (1/10/2013)

---

I agree that I should have used a tally table. I've been writing CTE's for counting for awhile and can do so while sleeping. I still fumble...

Jeff Moden (1/9/2013)

---

Alan.B (1/9/2013)

---

Did you mean "NOT" SARGable because it sure doesn't look SARGable from here. 😉 And,...

dwain.c (1/9/2013)

---

Alan - That's a very intriguing use of NTILE!

I would recommend, however that you change the way you construct your asciichar table:

;WITH asciichar(n, c) AS (

SELECT n=64+number, CHAR(64+number)

FROM [master].dbo.spt_values...

My appologies. In my last post I misread your question. Hopefully what GSquared posted helped.

AJB:

3) I used sys.database_files in...

AndrewSQLDBA (1/9/2013)

---

Hello Everyone

I hope that everyone is having a very good day.

I need to write a query to select row counts, but this seems like a lot of scanning of...

Danzz (1/9/2013)

---

Thanks for your reply Alan

I tried couple of ways, It did not work out

create table ##permission_info (id int primary key identity, information varchar(8000))

insert...

Jacob Pressures (1/9/2013)

---

Ok thanks for the info. Right now I'm trying to avoid D-SQL until i learn more about it.

The TVP seems, at least in my head, like an alternative...