that's really great. thank you a lot! it worked fine.

Could a MOD shift this into SQL2005 topic? sorry for that

sheh, mistrusting. ey...

I'll post it when I've got some time. Will use a tally table to crawl through the records

bah... it depends on the bureaucracy in the enterprise.... Never heard of IT Governance and Standard utilities ? :w00t:

However, do you have a cool trick to relabel the diffrent entries...

Jeff, wise guy - tell that the vendor! How easy our lives would be when people would think, ain't it?

Could imagine that I can improve performance in re-labeling this...

did have a thought on ranking, but as the table is being provided AS IS (why do people always report on 3rd party products databases ....) I must accept the performance...

how to do it then? its basically the same point of start but I have more values per ID

pity - yeah understand. but the problem of transforming rows to columns would exist in either way... why can't people just do normalized tables

no ideas here? or am I just to stupid, I would appreciate this answer as well

Playing the devils advocate... Jeff Modens SQL is absolutely a Must to know... There was - however - the comment that the MIN does not work when having more answers...