archie flockhart (3/4/2015)

---

Curious as to why the Break doesn't exit from the IF , as the referenced BOL page suggests that it should ? ( It clearly does work as...

Dave62 (2/18/2015)

---

I got it right but I don't think Steve got the answer to his question.

I would interpret that question...

Sean Lange (2/16/2015)

---

Great back to basics question. I am shocked at the response rate.

I am really surprised that so many people got...

You'd think so, but not necessarily. The line number means different things depending...

Sean Lange (11/11/2014)

---

No that wouldn't work. How would you know what rows to retrieve when using TOP if you had not already...

This isn't a mistake. It's Steve's subtle way of getting us to write more questions:

http://www.sqlservercentral.com/articles/SQLServerCentral/115420/

😀

I was making this a lot harder than it needed to be, until I remembered this part of PIVOT:

..

FOR

[<column that contains the values that will become column headers>]

IN ( [first...

It actually means:

Boy, I Miss Lucy.

😀

sdorris 90134 (8/6/2014)

---

Note: This has only been tested in SQL Server 2008 SP3

I tested this in SQL 2005 and your correct answer does not work. Are we to imply...

That may be true of a non-correlated subquery, but a correlated subquery depends upon some information from...

At its heart, a correlated subquery is simply one that refers to data from the outer query.

These are (non-correlated) subqueries:

SELECT DB_NAME()

, (SELECT count(*) FROM sys.objects) AS TotalObjects

, (SELECT count(*) FROM...

Koen Verbeeck (7/16/2014)

---

Raghavendra Mudugal (7/16/2014)

---

Koen Verbeeck (7/16/2014)

---

how you mean? "already"

this simple statement creates a clustered index

CREATE TABLE TT1

(

ID INT PRIMARY...

The final select returns a row containing Steve is correct because the synonym is pointed at the view called Test that points to the Test2 table. Depending on your outlook...

Good question.

As usual, though, "easiest" translates to "how you should most often not do it".

If @TrueFalse is anything other than 'TRUE', 'FALSE', '', or an integer string, you'll get an...

Setting aside the trace flag issue (I don't blame the question writer for Microsoft's inability to write proper documentation) the only problem I have with this question is the use...