SQL Server 2022

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

SELECT *
FROM (
    SELECT
        S1.value,
        NEWID() AS Id
    FROM GENERATE_SERIES(1, 3) S1
) S1
CROSS APPLY (
    SELECT
        S2.value,
        S1.Id -- Trying to repeat the same value multiple times
    FROM GENERATE_SERIES(1, 2) S2
) S2
ORDER BY S1.value, S2.value


value
Id
value
Id


1
3bc79624-e41f-4cfb-9086-fc6d5ff7caee
1
3bc79624-e41f-4cfb-9086-fc6d5ff7caee

1
4a622887-f8a1-4461-b728-ebe53d97f5ad
2
4a622887-f8a1-4461-b728-ebe53d97f5ad

2
b0f57247-cd00-479a-b08f-2a48080590a6
1
b0f57247-cd00-479a-b08f-2a48080590a6

2
e0470494-48e7-4dcb-8a49-0e57a943dbea
2
e0470494-48e7-4dcb-8a49-0e57a943dbea

3
6fdc6bcc-2bed-4190-b9e3-e9def5ff5e1c
1
6fdc6bcc-2bed-4190-b9e3-e9def5ff5e1c

3
bda78e5b-1e27-4f43-8362-5ec1c4b25ca4
2
bda78e5b-1e27-4f43-8362-5ec1c4b25ca4


-- Intermediate calculation
SELECT *
FROM (
    SELECT
        S1.value,
        NEWID() AS Id
    FROM GENERATE_SERIES(1, 3) S1
) S1
CROSS APPLY (
    SELECT
        S1.value,
        S1.Id,
        Replace(UPPER(CAST(S1.Id AS VARCHAR(50))), CONCAT('', S1.value), 'x')  AS Id2
) ID
CROSS APPLY (
    SELECT
        S2.value,
        ID.Id, -- Trying to repeat the same value multiple times
        ID.Id2 -- Trying to repeat the same value multiple times
    FROM GENERATE_SERIES(1, 2) S2
) S2
ORDER BY S1.value, S2.value


value
Id
value
Id
Id2
value
Id
Id2


1
cc2ceba7-e5dc-41a8-b7fd-e2fe39c035f8
1
cc2ceba7-e5dc-41a8-b7fd-e2fe39c035f8
CC2CEBA7-E5DC-4xA8-B7FD-E2FE39C035F8
1
cc2ceba7-e5dc-41a8-b7fd-e2fe39c035f8
CC2CEBA7-E5DC-4xA8-B7FD-E2FE39C035F8

1
d37d3c56-1046-4e5a-8ae6-033052daf2ec
1
d37d3c56-1046-4e5a-8ae6-033052daf2ec
D37D3C56-x046-4E5A-8AE6-033052DAF2EC
2
d37d3c56-1046-4e5a-8ae6-033052daf2ec
D37D3C56-x046-4E5A-8AE6-033052DAF2EC

2
effbab67-8262-4a7b-8824-022cd8fcfbef
2
effbab67-8262-4a7b-8824-022cd8fcfbef
EFFBAB67-8x6x-4A7B-88x4-0xxCD8FCFBEF
1
effbab67-8262-4a7b-8824-022cd8fcfbef
EFFBAB67-8x6x-4A7B-88x4-0xxCD8FCFBEF

2
64055d60-6d36-4fb0-a714-43f7836e2d07
2
64055d60-6d36-4fb0-a714-43f7836e2d07
64055D60-6D36-4FB0-A714-43F7836ExD07
2
64055d60-6d36-4fb0-a714-43f7836e2d07
64055D60-6D36-4FB0-A714-43F7836ExD07

3
6d84c87e-f47a-488a-b78f-0f0f192104c8
3
6d84c87e-f47a-488a-b78f-0f0f192104c8
6D84C87E-F47A-488A-B78F-0F0F192104C8
1
6d84c87e-f47a-488a-b78f-0f0f192104c8
6D84C87E-F47A-488A-B78F-0F0F192104C8

3
468477ef-f704-497d-b18a-99017badbac0
3
468477ef-f704-497d-b18a-99017badbac0
468477EF-F704-497D-B18A-99017BADBAC0
2
468477ef-f704-497d-b18a-99017badbac0
468477EF-F704-497D-B18A-99017BADBAC0


-- CTE
WITH S1 AS (
    SELECT
        S1.value,
        NEWID() AS Id
    FROM GENERATE_SERIES(1, 3) S1
)
SELECT *
FROM S1
CROSS APPLY (
    SELECT
        S2.value,
        S1.Id -- Trying to repeat the same value multiple times
    FROM GENERATE_SERIES(1, 2) S2
) S2
ORDER BY S1.value, S2.value


value
Id
value
Id


1
d9de287f-7cb3-46aa-a15e-2f24327438f2
1
d9de287f-7cb3-46aa-a15e-2f24327438f2

1
ac00c3b6-0b27-4ace-b049-0429afb53f08
2
ac00c3b6-0b27-4ace-b049-0429afb53f08

2
1f3c4c5b-c72f-4399-8f1b-67869d8b7430
1
1f3c4c5b-c72f-4399-8f1b-67869d8b7430

2
cc7aaf63-e0c6-40af-8dc0-d048cb4d0c27
2
cc7aaf63-e0c6-40af-8dc0-d048cb4d0c27

3
dd305025-d191-4cb9-ac2c-146244d5d08d
1
dd305025-d191-4cb9-ac2c-146244d5d08d

3
803a1873-1f9f-4899-a530-24ae86d0e846
2
803a1873-1f9f-4899-a530-24ae86d0e846


-- Multiple statements using a temp table works
DECLARE @Temp TABLE (value INT, Id UNIQUEIDENTIFIER)

INSERT @Temp
SELECT S1.value, NEWID() AS Id
FROM GENERATE_SERIES(1, 3) S1

SELECT *
FROM @Temp S1
CROSS APPLY (
    SELECT
        S2.value,
        S1.Id -- Trying to repeat the same value multiple times
    FROM GENERATE_SERIES(1, 2) S2
) S2
ORDER BY S1.value, S2.value


value
Id
value
Id


1
01ef5c4a-6ef8-4599-b9fe-b2e7044d0cc3
1
01ef5c4a-6ef8-4599-b9fe-b2e7044d0cc3

1
01ef5c4a-6ef8-4599-b9fe-b2e7044d0cc3
2
01ef5c4a-6ef8-4599-b9fe-b2e7044d0cc3

2
817228e4-58ad-4069-8a6e-3bdb56875c9a
1
817228e4-58ad-4069-8a6e-3bdb56875c9a

2
817228e4-58ad-4069-8a6e-3bdb56875c9a
2
817228e4-58ad-4069-8a6e-3bdb56875c9a

3
9c6bfea7-e954-4659-9113-3613fe2ab71b
1
9c6bfea7-e954-4659-9113-3613fe2ab71b

3
9c6bfea7-e954-4659-9113-3613fe2ab71b
2
9c6bfea7-e954-4659-9113-3613fe2ab71b

value	Id	value	Id
1	3bc79624-e41f-4cfb-9086-fc6d5ff7caee	1	3bc79624-e41f-4cfb-9086-fc6d5ff7caee
1	4a622887-f8a1-4461-b728-ebe53d97f5ad	2	4a622887-f8a1-4461-b728-ebe53d97f5ad
2	b0f57247-cd00-479a-b08f-2a48080590a6	1	b0f57247-cd00-479a-b08f-2a48080590a6
2	e0470494-48e7-4dcb-8a49-0e57a943dbea	2	e0470494-48e7-4dcb-8a49-0e57a943dbea
3	6fdc6bcc-2bed-4190-b9e3-e9def5ff5e1c	1	6fdc6bcc-2bed-4190-b9e3-e9def5ff5e1c
3	bda78e5b-1e27-4f43-8362-5ec1c4b25ca4	2	bda78e5b-1e27-4f43-8362-5ec1c4b25ca4

value	Id	value	Id	Id2	value	Id	Id2
1	cc2ceba7-e5dc-41a8-b7fd-e2fe39c035f8	1	cc2ceba7-e5dc-41a8-b7fd-e2fe39c035f8	CC2CEBA7-E5DC-4xA8-B7FD-E2FE39C035F8	1	cc2ceba7-e5dc-41a8-b7fd-e2fe39c035f8	CC2CEBA7-E5DC-4xA8-B7FD-E2FE39C035F8
1	d37d3c56-1046-4e5a-8ae6-033052daf2ec	1	d37d3c56-1046-4e5a-8ae6-033052daf2ec	D37D3C56-x046-4E5A-8AE6-033052DAF2EC	2	d37d3c56-1046-4e5a-8ae6-033052daf2ec	D37D3C56-x046-4E5A-8AE6-033052DAF2EC
2	effbab67-8262-4a7b-8824-022cd8fcfbef	2	effbab67-8262-4a7b-8824-022cd8fcfbef	EFFBAB67-8x6x-4A7B-88x4-0xxCD8FCFBEF	1	effbab67-8262-4a7b-8824-022cd8fcfbef	EFFBAB67-8x6x-4A7B-88x4-0xxCD8FCFBEF
2	64055d60-6d36-4fb0-a714-43f7836e2d07	2	64055d60-6d36-4fb0-a714-43f7836e2d07	64055D60-6D36-4FB0-A714-43F7836ExD07	2	64055d60-6d36-4fb0-a714-43f7836e2d07	64055D60-6D36-4FB0-A714-43F7836ExD07
3	6d84c87e-f47a-488a-b78f-0f0f192104c8	3	6d84c87e-f47a-488a-b78f-0f0f192104c8	6D84C87E-F47A-488A-B78F-0F0F192104C8	1	6d84c87e-f47a-488a-b78f-0f0f192104c8	6D84C87E-F47A-488A-B78F-0F0F192104C8
3	468477ef-f704-497d-b18a-99017badbac0	3	468477ef-f704-497d-b18a-99017badbac0	468477EF-F704-497D-B18A-99017BADBAC0	2	468477ef-f704-497d-b18a-99017badbac0	468477EF-F704-497D-B18A-99017BADBAC0

value	Id	value	Id
1	d9de287f-7cb3-46aa-a15e-2f24327438f2	1	d9de287f-7cb3-46aa-a15e-2f24327438f2
1	ac00c3b6-0b27-4ace-b049-0429afb53f08	2	ac00c3b6-0b27-4ace-b049-0429afb53f08
2	1f3c4c5b-c72f-4399-8f1b-67869d8b7430	1	1f3c4c5b-c72f-4399-8f1b-67869d8b7430
2	cc7aaf63-e0c6-40af-8dc0-d048cb4d0c27	2	cc7aaf63-e0c6-40af-8dc0-d048cb4d0c27
3	dd305025-d191-4cb9-ac2c-146244d5d08d	1	dd305025-d191-4cb9-ac2c-146244d5d08d
3	803a1873-1f9f-4899-a530-24ae86d0e846	2	803a1873-1f9f-4899-a530-24ae86d0e846

value	Id	value	Id
1	01ef5c4a-6ef8-4599-b9fe-b2e7044d0cc3	1	01ef5c4a-6ef8-4599-b9fe-b2e7044d0cc3
1	01ef5c4a-6ef8-4599-b9fe-b2e7044d0cc3	2	01ef5c4a-6ef8-4599-b9fe-b2e7044d0cc3
2	817228e4-58ad-4069-8a6e-3bdb56875c9a	1	817228e4-58ad-4069-8a6e-3bdb56875c9a
2	817228e4-58ad-4069-8a6e-3bdb56875c9a	2	817228e4-58ad-4069-8a6e-3bdb56875c9a
3	9c6bfea7-e954-4659-9113-3613fe2ab71b	1	9c6bfea7-e954-4659-9113-3613fe2ab71b
3	9c6bfea7-e954-4659-9113-3613fe2ab71b	2	9c6bfea7-e954-4659-9113-3613fe2ab71b