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 2000 Forums
 SQL Server Development (2000)
 find child messages for a perticular messageId in a thread

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2001-11-18 : 17:57:44
Arvind writes "Hi,

while going through a solution for getting all child messages for a perticular messageid in a thread.
I have seen this following your page

http://www.sqlteam.com/item.asp?ItemID=1353

I have exactly same structure in my database.
Like
---------------------------------------------------------
Id | ParentMsgId | ThreadId | Replylevel | dateofPosting
---------------------------------------------------------

I want to delete all submessages for a perticular messageid in thread.I have one more column "replylevel" also for level of message in that table.

Can you please help me to find good way to solve this.
Or any subquery.

Regards
Arvind"
   

- Advertisement -