GO
SET ANSI_NULLS ON
GO
ALTER PROCEDURE adm_TerritoryCategoryWrite_Remove
@removedata text
AS
DECLARE @table TABLE (ID int)
DECLARE @hDoc int
exec sp_xml_preparedocument @hDoc OUTPUT, @removedata
insert into @table select * FROM OPENXML(@hDoc, 'delete/TerritoryCategory')
WITH (ID int)
EXEC sp_xml_removedocument @hDoc
-- select * from @table t
Delete from TerritoryCategory where TerritoryCategory.TerritoryCategoryID in (select * from @table t)
--Select * from TerritoryCategory
GO
SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON
GO
posted by Soumalyade @ 2:24 AM
