Two things. (1) the use of upper indicates your database should be set to be case insensitive. (2) creating a table doesn't get you out of testing in...

I thought it would be a frienfly question, so I picked Amicable numbers...

bvrolyk (7/17/2013)

---

This is my issue as well. I need Father3 displayed in the final result set.

In my "real world problem" I need to list the fathers with no children, not...

A better approach is to get the info from the original...

Did you intend for the WITH with a GO before it to be a red herring? I knew you could do the insert, but the question seemed simple and...

patrickmcginnis59 10839 (12/9/2013)

---

I'm interested in why RBAR is so slow in SQL systems, and some of the following psychology that develops around this is pretty interesting too. I've seen stuff...

dwain.c (9/26/2013)

---

I love extended properties. Very comprehensive introductory article!

The only think I find annoying about them (unless I missed something) is that you can't update them. Need to...

I got it right, but I wish the date wasn't April Fools day -- it adds a bit of "meta" distraction to the question.

Is it ha, ha fooled you if...

Except that for a site that you visit once a week, let alone once a...

Barry Wright-268269 (1/17/2013)

---

It seems to me that a big factor in this is just password fatigue. We have so many password "protecting" things from the very important like bank...

SanDroid (12/26/2012)

---

A spatial index is the only right one for this task.

Since Elves do not exist on this Planet/Reality it...

Ninja's_RGR'us (3/21/2011)

---

-snip-

And just for fun, a recursive CTE solution! :hehe:

DECLARE @t varchar(max);

SET @t = '';

WITH rectags AS

(

SELECT TOP 1 Tag FROM Tags ORDER BY Tag

UNION ALL

(

SELECT ', ' +...

GilaMonster (12/29/2008)

---

If your goal is to corrupt your database and cause downtime and loss of data, sure.

It...

Not...

George H. (6/26/2012)

Why does SQL Server spit the results out in this format rather than in straight binary, like this:

01100001 01100010 01100011 01100100 01100101 01100110 01100111

I apologize if this is...