SQL Server 2022

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

-- Function to split a string composed of a list of Guids, into a list of Guids

CREATE FUNCTION SplitStrings_XML
(
   @List       NVARCHAR(MAX),
   @Delimiter  NVARCHAR(255)
)
RETURNS TABLE
WITH SCHEMABINDING
AS
   RETURN 
   (  
      SELECT Item = y.i.value('(./text())[1]', 'nvarchar(4000)')
      FROM 
      ( 
        SELECT x = CONVERT(XML, '<i>' 
          + REPLACE(@List, @Delimiter, '</i><i>') 
          + '</i>').query('.')
      ) AS a CROSS APPLY x.nodes('i') AS y(i)
   );
-- Checking that the function works

SELECT * FROM SplitStrings_XML('0addb335-ad0a-4408-9add-22ff16c79535,
7f5b4850-4450-491b-82cb-e0394ce301e7,
9ca0c3cb-6051-4797-a7ce-339cea67b69a,
70c327d0-09b0-4c02-9b21-fa375a9c58c8', ',');


Item


0addb335-ad0a-4408-9add-22ff16c79535


7f5b4850-4450-491b-82cb-e0394ce301e7


9ca0c3cb-6051-4797-a7ce-339cea67b69a


70c327d0-09b0-4c02-9b21-fa375a9c58c8


-- Schema creation

CREATE TABLE SavedPlace (
	SavedPlaceId       UNIQUEIDENTIFIER NOT NULL
	  CONSTRAINT PK_SavedPlace PRIMARY KEY,
	[Name]        NVARCHAR(100)    NOT NULL,
	IsOpen        BIT              NOT NULL
);

CREATE TABLE OutputTable (
	SavedPlaceId       UNIQUEIDENTIFIER NOT NULL,
	[Name]              NVARCHAR(100)    NOT NULL,
	IsOpen              BIT              NOT NULL
);
INSERT INTO SavedPlace
(SavedPlaceId, [Name], IsOpen)
VALUES
(N'315472ae-0e88-49d3-a8bc-97d4ca550509', N'a', 0),
(N'8c24f8e2-bafa-4e54-9f11-dbf1a01e1865', N'b', 0),
(N'f525bbba-ecaf-41ab-9da4-cfc8d238da72', N'c', 0),
(N'5baff2d2-e97b-4da9-a2bb-ff8d9a8f3090', N'd', 0),
(N'e18ea843-f2bc-4e5c-900e-09e4722d343c', N'e', 0),
(N'b5756fbe-f484-44e5-adae-05d8f46a4151', N'f', 0);
6 rows affected

SELECT * FROM SavedPlace;


SavedPlaceId
Name
IsOpen


b5756fbe-f484-44e5-adae-05d8f46a4151
f
False

e18ea843-f2bc-4e5c-900e-09e4722d343c
e
False

315472ae-0e88-49d3-a8bc-97d4ca550509
a
False

f525bbba-ecaf-41ab-9da4-cfc8d238da72
c
False

8c24f8e2-bafa-4e54-9f11-dbf1a01e1865
b
False

5baff2d2-e97b-4da9-a2bb-ff8d9a8f3090
d
False


CREATE PROCEDURE spSavedPlaces
	@GuidList NVARCHAR(MAX)
AS
BEGIN

    SET NOCOUNT ON;

	INSERT INTO OutputTable(
	  SavedPlaceId,
      [Name],
	  IsOpen
	)
	  SELECT
	    SavedPlaceId,
        [Name],
	    IsOpen
	  FROM (UPDATE P
              SET
			    IsOpen = 1

            OUTPUT
	          INSERTED.SavedPlaceId,
              INSERTED.[Name],
              INSERTED.IsOpen

           FROM SavedPlace AS P

           -- WHERE P.PlaceId IN 'the table returned by the SplitStrings_XML function'
      
      ) AS NDML -- End of nested DML

END
EXEC spSavedPlaces @GuidList = N'b5756fbe-f484-44e5-adae-05d8f46a4151,e18ea843-f2bc-4e5c-900e-09e4722d343c,315472ae-0e88-49d3-a8bc-97d4ca550509';

SELECT * FROM OutputTable;


SavedPlaceId
Name
IsOpen


b5756fbe-f484-44e5-adae-05d8f46a4151
f
True

e18ea843-f2bc-4e5c-900e-09e4722d343c
e
True

315472ae-0e88-49d3-a8bc-97d4ca550509
a
True

f525bbba-ecaf-41ab-9da4-cfc8d238da72
c
True

8c24f8e2-bafa-4e54-9f11-dbf1a01e1865
b
True

5baff2d2-e97b-4da9-a2bb-ff8d9a8f3090
d
True

SavedPlaceId	Name	IsOpen
b5756fbe-f484-44e5-adae-05d8f46a4151	f	False
e18ea843-f2bc-4e5c-900e-09e4722d343c	e	False
315472ae-0e88-49d3-a8bc-97d4ca550509	a	False
f525bbba-ecaf-41ab-9da4-cfc8d238da72	c	False
8c24f8e2-bafa-4e54-9f11-dbf1a01e1865	b	False
5baff2d2-e97b-4da9-a2bb-ff8d9a8f3090	d	False

SavedPlaceId	Name	IsOpen
b5756fbe-f484-44e5-adae-05d8f46a4151	f	True
e18ea843-f2bc-4e5c-900e-09e4722d343c	e	True
315472ae-0e88-49d3-a8bc-97d4ca550509	a	True
f525bbba-ecaf-41ab-9da4-cfc8d238da72	c	True
8c24f8e2-bafa-4e54-9f11-dbf1a01e1865	b	True
5baff2d2-e97b-4da9-a2bb-ff8d9a8f3090	d	True