quote:

---

Originally posted by _michael_

Hey guys, I have 2 tables:

Attributes				AtrributeVales			
attrId(PK)	name			id (PK)	attrId(FK)	value
1		color			1	1		green
2		size			2	2		small
					3	1		red
					4	2		medium
					5	1		blue
					6	2		large

I need to build some query that will return something like this:
Color	Size
Green	small
Red	medium
Blue	large

Any ideas of how accomplish this task??? Any kind of help would be appreciated...

---

select	[color], [size]
from	(
		select	row = (av.id-1)/2, av.value, a.name
		from	AttributeValues av
			inner join Attributes a	on	av.attrId	= a.attrId
	) d
	pivot
	(
		max(value)
		for name in ([color], [size])
	) p