Help with pivot statement - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

Transact-SQL (2005)

Help with pivot statement

Author

Topic

klakieros
Starting Member

1 Post

Posted - 2009-10-06 : 04:50:09

Hi All,
I need help with pivot query please.

this is a result from standard select statement:

taskid taskDesc
1 check milk
2 check coffee
3 check machine

Now, I need this converted into one flat row like this:

taskDesc check milk check coffee check machine

column 'taskid' is not required. All I need is all three task desciptions in one row to later use it with mail merge.
Any help will be appreciated,
Regards,
Pawel

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2009-10-06 : 05:03:17

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=81254

N 56°04'39.26"
E 12°55'05.63"

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources