Combine Multiple rows into single column

Question

Combine Multiple rows into single column

Viewing 3 posts - 16 through 17 (of 17 total)

You must be logged in to reply to this topic. Login to reply

amazona Grasshopper Points: 23 More actions · Answer 1

Sorry Mark, I didn't see your solution before posting my version of the same thing.

I find it strange that TSQL doesn't have built-in cross-tab query functionality whereas Access does. It's quite a common requirement.

Cheers,

Stephen Sjodin

Mark Cowne One Orange Chip Points: 26952 More actions · Answer 2

amazona (11/27/2009)
Sorry Mark, I didn't see your solution before posting my version of the same thing.
I find it strange that TSQL doesn't have built-in cross-tab query functionality whereas Access does. It's quite a common requirement.
Cheers,
Stephen Sjodin

Not really my solution, was posted by Lynn earlier.

____________________________________________________

Deja View - The strange feeling that somewhere, sometime you've optimised this query before

How to get the best help on a forum

http://www.sqlservercentral.com/articles/Best+Practices/61537

amazona Grasshopper Points: 23 More actions · Answer 3

Sorry Lynn, I didn't see your solution before posting my version of the same thing.

I find it strange that TSQL doesn't have built-in cross-tab query functionality whereas Access does. It's quite a common requirement.

Cheers,

Stephen Sjodin