Post_15_4.sql

CREATE PROCEDURE [dbo].[UpdateChildItems]
	@ParentItemId INT,
	@ChildItems ChildItemsType READONLY
AS
BEGIN
	MERGE ChildItems AS t
	USING (SELECT Id, ParentItemId, SomeProperty1, SomeProperty2, SomeProperty3 FROM @ChildItems) AS s
	ON t.Id = s.Id AND t.ParentItemId = s.ParentItemId
	WHEN MATCHED THEN
		UPDATE SET t.SomeProperty1 = s.SomeProperty1, t.SomeProperty2 = s.SomeProperty2, t.SomeProperty3 = s.SomeProperty3
	WHEN NOT MATCHED BY TARGET THEN
		INSERT (ParentItemId, SomeProperty1, SomeProperty2, SomeProperty3) 
			VALUES (s.ParentItemId, s.SomeProperty1, s.SomeProperty2, s.SomeProperty3)
	WHEN NOT MATCHED BY SOURCE AND t.ParentItemId = @ParentItemId THEN
		DELETE;
END