Brilliant! This works, exactly the result I wanted.

Are there any cons to returning the data this way? I can't see any, really. I'll be returning 3000 nodes which have...

Okay, here's the CREATE

CREATE TABLE [dbo].[tbltest](

[id] [int] NULL,

[name] [varchar](50) NULL,

[value] [varchar](50) NULL

) ON [PRIMARY]

GO

Here's some data

DECLARE @count INT

SET @count = 0

WHILE (@count < 100)

BEGIN

INSERT INTO tbltest (id,...

Hey guys. Thanks for replying. Fair point about the details. I'm away from the computer at the moment but I shall upload an example as soon as. Please bear with...