3
Answers

sql cte to join two results in one common

Rehaan Ahmed

Rehaan Ahmed

6y
503
1
;WITH
group1 AS
(SELECT item as Products from dbo.fnParseDelimitedString('mango,apple,pears,kiwi',',')),
group2 AS
(SELECT item as Price from dbo.fnParseDelimitedString('$3.19,$2.45,$5.00,$2.59',','))
--select Products from group1
select Price from group2

i want to get one result joining both the cte?

Like Products || Price

Answers (3)