I'm going to talk to Kevin Kline if I can track him down. (@KEKline on Twitter, I think.) He's a serious smarty (SQL Server MVP), so his advice should...

Just wondering - since I'm not absolutely new to SQL Server (I have a couple of those Microsoft pieces of paper) but lack paid experience in SQL Server, what would...

You might want to read Dwain Camps' article on Creating Dynamic Crosstabs... that might give you some ideas.

SQL Saturday? It's a bargain, so absolutely go! You may not understand it all, but go to beginner lectures (I went to the one in Nashville last week,...

Can you use SSRS, or are you doing this in a query only?

Just wondering, but can you force the queries to run in a single transaction, so they all execute and then the report is rendered? (Sorry to hijack the post...

Maybe a naive question, but why most if not all of the grouping in SSRS? Then you can drill up and down in your report. So you would...

Is that your intended input or output? Either way, in order to help you, please post both. I created a dummy query for the data you provided:

SELECT ...

You need a tutorial on basic queries. Most of these are trivial - like the last answer I posted.

If you tested your code, you would know that it wouldn't...

One way...

CTE??? Isn't that overkill?

create table #tab

(

ref_group varchar(15),

product varchar(10),

qty tinyint

);

insert into #tab(ref_group,product,qty)

values ('Milk Products','Curd',25);

insert into #tab(ref_group,product,qty)

values ('Milk Products','Butter',5);

SELECT ref_group

, product

, qty

FROM #tab t1

WHERE t1.qty = (SELECT MIN(qty)

FROM #tab);

Can't you just set the parameter to be multi-valued in the report? Then you can use JOIN() to get the items in the list into a single string...

Or did...

Okay. I could get the name of the column outside of the code, but not inside. I'll give it another try and see if I can get closer....

Dwain,

cool code! I'll have to dig in and figure out how it works. One thing is missing though... the Symptom name disappeared. The final output should look...

Dwain,

cool code! I'll have to dig in and figure out how it works. One thing is missing though... the Symptom name disappeared. The final output should look...

"There are multiple categories for each product."

That's unusual. Could you give an example? Normally, you have a category hierarchy (Category, Subcategory...)