Has anyone found a solution to this.

We are experiencing exactly the same problem. I have ruled out recordets/sessions and any erroneous open connections by disabling all other websites except a...

Another alternative post

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=8&messageid=160502#bm160753

Very similar to Franks link but variety is the spice of life .

You could try creating a UDF like the one below;

CREATE FUNCTION dbo.f_get_item_codes (@item nvarchar(256))

RETURNS VARCHAR(256)

AS

BEGIN

DECLARE @codes VARCHAR(256)

SELECT @codes = '' /*eliminating NULL value*/

SELECT @codes = @codes + it.code + ','

FROM...

Ideally this would be dynamic because its something I'm going to need alot in the future.

As a background the information is for an online directory taken from a print publication...