A GROUP BY question

Question

Viewing 5 posts - 1 through 4 (of 4 total)

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

Ron McCullough SSC Guru Points: 63877 More actions · Answer 1

Reply removed since it did not answer the question properly ... sorry about that

If everything seems to be going well, you have obviously overlooked something.

Ron

Please help us, help you -before posting a question please read[/url]
Before posting a performance problem please read[/url]

Lynn Pettis SSC Guru Points: 442467 More actions · Answer 2

I think this thread will provide you with what you need to solve your problem.

Let us know if it helps.

Joel Ewald SSCertifiable Points: 6120 More actions · Answer 3

I do not know your table structure, but you can do something like the following.

--function to concatenate categories into comma seperated list by title

CREATE FUNCTION dbo.fn_GetCategoriesForTitle (@TitleId int )

RETURNS varchar(MAX)

AS

BEGIN

DECLARE @Categories varchar(max)

SELECT @Categories = COALESCE(@Categories + ', ', '') + R.CatId

FROM (SELECT DISTINCT

CAST(CatId as varchar) as CatId

FROM dbo.TitleCategories

WHERE TitleId = @TitleId ) R

RETURN @Categories

END

GO

--return titles and comma seperated list of categories

SELECT

T.ArtId,

T.Title,

dbo.fn_GetCategoriesForTitle(T.TitleId) as CatId

FROM dbo.Titles

lucas johnson SSC Enthusiast Points: 174 More actions · Answer 4

Thanks this function worked. Of course, I had to change it a bit but it is one of those lessons learned for future use. Again, Thank you.