select	[id]
	,sum(x) as x
	,sum(y) as y
from	(
	select	[id]
		,x = case when xy = 'x' then val else 0 end
		,y = case when xy = 'y' then val else 0 end
	from	(--Your source result set
		select 1 as [id], 'x' as xy, 10 as val union
		select 1, 'y', 100 union all
		select 2, 'x', 20 union all
		select 2, 'y', 200
		) a
	) a
group by [id]

EDIT:
output of source:
id          xy   val         
----------- ---- ----------- 
1           x    10
1           y    100
2           x    20
2           y    200


output of results
id          x           y           
----------- ----------- ----------- 
1           10          100
2           20          200

quote:

---

tableXY(listPosition, coords) - where the coords alternate between x and y. i.e. the first tuple is x, the second tuple is y, the 3rd tuple is x, the fourth tuple is y etc

---

quote:

---

Originally posted by elwoos

quote:

---

tableXY(listPosition, coords) - where the coords alternate between x and y. i.e. the first tuple is x, the second tuple is y, the 3rd tuple is x, the fourth tuple is y etc

---

This is a very high risk assumption to make as the order is not guaranteed. TG is right you need to post your source structure then someone can help you come up with a better solution

steve

-----------

Oh, so they have internet on computers now!

---

set nocount on
declare @src table ([position] int, vertices numeric(15,6))
insert @src
select 1, 32443.2324 union all
select 2, 32432.324324 union all
select 3, 32424.324324  union all
select 4, 324324.324324  

select	x.vertices as x
	,y.vertices as y
from	@src x
join	@src y
		on y.position -1 = x.position	--Count on Position to alternate Xs and Ys
		and x.position % 2 > 0 		--make sure Xs are odd numbers
		and y.position % 2 = 0 		--make sure Ys are event numbers
order by x.position

output:
x                 y                 
----------------- ----------------- 
32443.232400      32432.324324
32424.324324      324324.324324

xPosition   yPosition   xVertices         yVertices         
----------- ----------- ----------------- ----------------- 
1           2           32443.232400      32432.324324
2           3           32432.324324      32424.324324
3           4           32424.324324      324324.324324
4           NULL        324324.324324     NULL

create table #job(id int, x float, y float)
set nocount on
go

declare @xytable table (position int, vertices float)
declare @i int
	,@x float
	,@y float
	,@id int
	,@cnt int
	,@s datetime

set @i = 1
while @i < 5000
begin
	insert @xytable 
	values (@i, @i*100)
	set @i = @i+ 1
end

select	@i = 1
	,@cnt = (SELECT count(position) FROM @XYTable)

set @s = getdate()
--WHILE @i <= (SELECT count(position) FROM @XYTable)
while @i <= @cnt
BEGIN 
	SELECT @x = xValue.vertices
	FROM @XYTable xValue
	WHERE xValue.position= @i
	
	SELECT @y = yValue.vertices
	FROM @XYTable yValue 
	WHERE yValue.position = (@i + 1)
	
	INSERT INTO #job(ID, x, y)
	VALUES(@ID, @x, @y)
	
	SET @i = @i + 2 
END
select datediff(millisecond, @s, getdate()) as milliseconds_ToLoop

truncate table #job

set @s = getdate()
insert #job
select	x.position
	,x.vertices as x
	,y.vertices as y
from	@xytable x
join	@xytable y
		on y.position -1 = x.position	--Count on Position to alternate Xs and Ys
		and x.position % 2 > 0 		--make sure Xs are odd numbers
		and y.position % 2 = 0 		--make sure Ys are event numbers
order by x.position

select datediff(millisecond, @s, getdate()) milliseconds_SetBased
drop table #job


milliseconds_ToLoop 
------------------- 
3466

milliseconds_SetBased 
--------------------- 
46