thx for the input

here is a stored proc that seemed to do the trick for me

I got it from --> http://www.swynk.com/sqlscripts/misc7-2.asp

SET QUOTED_IDENTIFIER OFF

GO

SET ANSI_NULLS ON

GO

/*

Pivot Table...

could someone please elaborate on what a "Set based approach" would be?

I have a stored proc that uses a similar algorithm to this one ...i.e. loops through a recordset and...