Here's an article that touches on using FOR XML PATH to do this type of concatenation.

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

If you need some more help with writing the code, please post sample data in...

Just because your query doesn't return any rows, it doesn't mean that the server didn't have to read through a large amount of data to come to the conclusion that...

What are you using to verify that you only get a space? You're not going to see it in QA or SSMS, as they don't show things like carriage...

This is the method that I prefer. For this running total...

Well, in that case, you need part 2 of the article ;-).

http://www.sqlservercentral.com/articles/Crosstab/65048/

That Jeff, always thinkin ahead.

This is an interesting request. Can you explain a bit further? Does the action that is failing not actually need to happen? If so, why is it...

What you're trying to do is known as a running total. Ordinarily, I'd point you to Jeff's article on it, but it's under construction as he is re-writing it....

Oh yeah, didn't even notice those were functions. That's likely major issue #2. Please post the code for the functions as well. If they're simple enough, pulling...

At a glance (Gail has the right of it, please post what she asked for), these 2 may be causing significant problems.

SELECT EfaYear

FROM EfaCalendarDates

WHERE ...

Take a look at the article in my signature by Jeff Moden on Cross Tabs. Post back if you have questions.

Jacob Pressures (10/5/2009)

---

Is the only purpose of PARTITION BY only to break the number sequence and start over? Does it have any other purpose? It just seems like a...

PIVOT needs to aggregate something. You're not aggregating anything, thus the error. You really don't need PIVOT at all, you can use something like this:

select g.studentid, g1.guardianname, g2.guardianname

from...

SQL 2000...

Roust_m (10/1/2009)

---

The reason I want this is because I need to run an import script which runs better when indexed views are not there yet, which relies on a stored...

bitbucket-25253 (10/2/2009)

---

Garadin

These were my test conditions using Developer version of SQL Server 2008 Microsoft SQL Server Management Studio 10.0.1600.22 ((SQL_PreRelease).080709-1414 )

/

ALTER DATABASE Test

SET COMPATIBILITY_LEVEL = 100

CREATE TABLE Dbo.NonExisting

(ABC...