Hello,
I have an SQL Stored Procedure that uses Inner Join to return the
records of various related tables:
SELECT * FROM dbo.by27_Blogger_Posts p
LEFT JOIN (
 SELECT *
 FROM dbo.by27_Blogger_Comments c
 LEFT JOIN dbo.by27_Membership_Users u
 ON c.AuthorId = u.UserId) AS cu
ON p.PostId = cu.PostId
...
WHEREp.PostId = @PostId
ORDER BY p.PostUpdatedDate

Now I get a dataset with all this data.
How can I, for example, loop through each PostId? And for each PostId
loop through each CommentId associated to it? And of course access the
columns?

The SQL code section I post applies to the 2 tables:
[Posts] > PostId, Title, ...
[Comments] > CommentId, PostId, Body, ...

Thanks,
Miguel