quote:

---

set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
go





-- =============================================
-- Author: <Author,,Name>
-- Create date: <Create Date,,>
-- Description: <Description,,>
-- =============================================
ALTER PROCEDURE [dbo].[TypeInSections_DeleteAll]
(
@SectionId int

)
AS
declare @ParentCoutn int,
@DumySectionIs int


BEGIN

set @ParentCoutn= (select count(sectionParentId) from sections where sectionParentId=@SectionId)

if(@ParentCoutn>0)
begin
declare Section cursor for
select SectionId
from sections
where sectionParentId=@SectionId

open Section

fetch Section into @DumySectionIs

WHILE @@Fetch_Status = 0
begin
execute TypeInSections_DeleteAll @DumySectionIs

fetch Section into @DumySectionIs
end

CLOSE Section

DEALLOCATE Section

end

else

begin
delete from TypesInsection where sectionId=@SectionId
end



END

---