What version of SQL Server are you on?

One more version. A little more dynamic. Also returns the results in the same order you listed.

CREATE TABLE #Test

(MyName varchar(10), MyCommaData varchar(50));

INSERT INTO #Test

SELECT 'Tom', '10,20,30,40' UNION ALL

SELECT...

Try this one. It is more of a kluge especially if there are a bunch of values in the delimited list.

CREATE TABLE #Test

(MyName varchar(10), MyCommaData varchar(50));

INSERT INTO #Test

SELECT 'Tom',...

I am with Lynn on this. Why must it be done without a function?

It can be done without a function but takes a bit more code. The use...

Lynn Pettis (8/4/2014)

---

Don't you just love people that ask for help but tell you it can't be a certain way, especially when the way the say it can't be done...

djj (8/4/2014)

---

Found this from Paul S. Randal of SQLskills.com:

"Here's the rule: if my 14-yr old smart daughter could find the answer on Google from your question, you'd shouldn't ask or...

Andrew Kernodle (8/4/2014)

---

... You know, now that I think about it... 😛

But eh, frustrating though it may be, I'll just have to get some climbing gear out and...

Andrew Kernodle (8/4/2014)

---

Oh geez. I feel quite operatic in the sense of this article lately 😛

The sysadmin here decided a few weeks back that the CPU usage of the...

irvidesai (8/4/2014)

---

Thanks for the reply. So the alter login has to be done manually on that accounts that are not in compliance correct? can that be automated? Is there a...

Gary Varga (8/4/2014)

---

What is the old saying? "A stitch in time saves nine!!!"

There is no reason for computing to be any different to anything else. I cannot remember the number...

anthony.green (8/4/2014)

---

Then you need to order the results and select the top X amount

SELECT

*

FROM

Property

WHERE

Beds = 2

AND

Location = 'XYZ'

ORDER BY

Baths DESC, -- more baths the better

Price ASC, -- less price the...

Phil Factor (8/4/2014)

---

I'm sorry if it got scored too high, but when I ask this as part of a technical interview, it seems to stump a very large proportion of...

+1

Tune the insert, get the insert to finish.

Wait until an outage window when nobody will be connecting to the database and do your index then

Ok, that tells a tale of a much smaller table than what you were showing before.

I bet there was blocking, or memory thrashing, or slow io, or any number of...