DECLARE @TableA

TABLE (

city VARCHAR(50) NOT NULL

);

...

This link explains FOR XML PATH:

http://www.simple-talk.com/sql/t-sql-programming/concatenating-row-values-in-transact-sql/

I don't understand the question either, but this MSDN reference might help:

User-Defined Function Basics

shini2007 (9/16/2010)

---

I think":" Converting to bit promotes any nonzero value to 1" not greater than zero only Because

DECLARE @bit BIT

SET @bit = -14

IF @bit = 1PRINT 'yes'ELSE PRINT...

For further details about that query plan, see:

http://sqlblog.com/blogs/paul_white/archive/2010/07/28/the-segment-top-query-optimisation.aspx

That entry also covers other possibilities including solutions using ranking functions, for example:

SELECT Ranked.HistoryID,

Ranked.ObjID,

...

The most efficient execution avoids any joins:

That's a single ordered scan of an index. One way to achieve that plan is to change the clustered index:

CREATE TABLE X

...

Apologising seems to be this week's theme :laugh:

Which one?...

Trey Staker (9/16/2010)

---

Paul White NZ (9/16/2010)

---

WayneS (9/16/2010)

---

Paul, I've really liked those articles. Heck, all of your articles have been keepers. Thanks for being a part of this community, and for...

GilaMonster (9/16/2010)

---

Paul White NZ (9/16/2010)

---

Perhaps a course on the correct...

Perhaps a course on the correct use of apostrophes next?

😛

TravisDBA (9/16/2010)

---

That was way out of line Paul. I was not being any such thing at all. I just said that I had already stated that previously and for the...

It's usually safe to assume cock-up over...

I see! Let me give you the glass-half-full bolded version, just for comparison:

Gail, Will you accept my apology? Sometimes in a...

Christian Buettner-167247 (9/16/2010)

---

In general I assume there is no single source of information, just lots of experience & knowledge built over the years, and a lot of exploration to build...