Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 Transact-SQL (2005)
 get number of replies in blog system

Author  Topic 

grimmus
Yak Posting Veteran

53 Posts

Posted - 2008-06-24 : 16:40:31
Hi,

I have a simple blog with a posts and replies table.

on the posts summary page i want to count the number of replies related to each post.

I thought i could store all the posts in a table variable and then loop through the table variable to count the number of replies that relate to the current post.

It doesnt seem as easy as i expected and i think i am making it more complicated for myself.

Can someone point me in the right direction please ?

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2008-06-24 : 16:49:02
http://weblogs.sqlteam.com/jeffs/archive/2008/05/13/question-needed-not-answer.aspx



E 12°55'05.25"
N 56°04'39.16"
Go to Top of Page
   

- Advertisement -