npodlesny (12/5/2013)

---

Correct.

Just for the record, I upgraded all my SQL Server components to Service Pack 2 (Microsoft...

Carlo Romagnano (12/5/2013)

---

Starting from sqlserver2008, you can declare and set a variable in one statement,

but you can NOT initialize a second variable with another inside the same declaration.

declare @a varchar=...

Well I thought I would give an easy one to "make up" for the "Order My Data" question I submitted. But you would be...

npodlesny (12/3/2013)

---

Interesting question. I like it and I do use date variables in SSIS Send Mail Task.

Did anyone tried to verify the given "right" answers?

Here what I've got by...

Mauve (12/3/2013)

---

It IS NOT guaranteed! Your test cases are invalid! Case in point:

I have a table with an IDENTITY column as the PK with a clustered index...

Sean Lange (12/3/2013)

---

steve.jacobs (12/3/2013)

---

rmunwin (12/2/2013)

---

I could be wrong but if you pop the server into single user mode and an index that uses a as a lead column will return...

rmunwin (12/2/2013)

---

I could be wrong but if you pop the server into single user mode and an index that uses a as a lead column will return results in order...

Nice question.

Thanks

All,

Again, my apologies for neglecting to be more clear when asking the question. From Igor's initial comment to this question, I immediately knew I messed up and was going...

Igor, you are correct and thank you for pointing it out. If you...

:-D. SOUNDEX (and DIFFERENCE) has always intrigued me...

webrunner (11/26/2013)

---

Amazing question. Even more amazing is that I got it right. I guessed, admittedly. But I will run and study the code, because it's a really cool puzzle.

By the...

Rune Bivrin (11/26/2013)

---

If SOUNDEX() as implemented in SQL Server was remotely useful outside of English-speaking countries I might care one way or the other. As it stands it's one of...

steve.jacobs (11/25/2013)

---

Me too :ermm:. ...

Me too :ermm:. I...