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)
 Loop Query

Author  Topic 

sandesh_moghe
Constraint Violating Yak Guru

310 Posts

Posted - 2001-08-07 : 02:29:56
Hi,
I have one table in which there are two fields, say
ItemId, ParentItemId
where ParentItemId is refering the same table.ParentItemId is null allowed.
So How can i delete the whole item?(Query?)
Ho can i use loop to solve this problem?
Thanx in advance.


Sandesh - The Messanger
   

- Advertisement -