/****** Object:  StoredProcedure [dbo].[sp_SetStatuses]    Script Date: 27.11.2017 22:38:03 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[sp_DropSectionDependSettingsWithChilds]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[sp_DropSectionDependSettingsWithChilds]
GO

CREATE PROCEDURE [dbo].[sp_DropSectionDependSettingsWithChilds]
 @SectionDependSettingsID uniqueidentifier
AS
BEGIN
 SET NOCOUNT ON;
 DECLARE @sql varchar(max)
	set @sql = 'DELETE dl
	FROM fies.T_SECTION_DEPEND_SETTINGS sds
	JOIN fies.T_SECTION_DEPEND_SETTINGS dl ON  '+ (select [dbo].[Joint]('(sds.' + sectionAlias+'= dl.' + sectionAlias + ' OR sds.' + sectionAlias + ' IS NULL)', ' AND ')
	from FIES.T_PLAN_SECTION) + '
	where sds.SectionDependSettingsID = ' + CAST(@SectionDependSettingsID AS VARCHAR(40))

	exec sp_executesql @sql

END


GO

