Tx, yes I mean dynamic groupers, I think it can be replaced with just literal so column will be there but no actual grouping will happened.

Best

Mario

Thanks, Sean and Koen.

It's pretty strighforward:

case col1

when '001' then 'alpha'

when '002' then 'bravo'

....

when '500' then 'zulu500'

else 'unkknown'

So I'll go with lookup table, to make...

You can also do you own AVG like =1.0*Total_Days/Total_Count, that 1.0 it will you give you bunch of decimals places,

AVG has its own defaults I think.

Mario

Tx a lot, it works,

is it possible to operate only on few columns from sp output ?

I don't need all and don't want to do extra temp table.

Best

M

Hi,all

I think I have success story, figured it out

THanks Livingston for your post, just saw yours too, thanks all support

select id1, id2,

( SELECT --id1, id2,

...

Thanks, all

Thansk, Dwaine

M

Thank CCChamp,

I can't go with top on main Select because I have a big list for Alpha, Bravo, Chrlie,.... Meanhile I change top 1 for max() and it...

Tx,

Sorry but I need format on report like on my sample:

2011 | 2012

______________

prod01 | prod03

prod03 | prod02

Thanks, Alan and Tee.

It's good enough for me to know that I can have 4 pages with diff datasets, they all just belong to each other logically but...

Thanks, Erland !

That's exactly I was looking for

Mario

Thanks, Jeff

I definitely need more prep for APPLY.

I don't think it's possible for Dwain sample (other sample from Scott has Joins).

I tried to translate it to Join and it never...

Thanks, Jeff

I just started to go into CROSS APPLY, being a JOIN person I'm trying to translate in into join, and still can't make it work as in original CROSS...

Dwain,

trying to reverse eng your super code, is this a place to use Cross Apply ONLY, or could be done with Join.

I can't get second Cross Apply

--CROSS APPLY...

Thanks, Scott

Your code works fine, and much easy to digest ( or learn if you will), amazing.. and thanks again to you and Dwain for sharing this, sure you can...

Eventually I made i work BUT only from Query Designer loading string delimited by ',' into table and use this table

But I still can not select multi values...