Rehaan Ahmed

Rehaan Ahmed

  • 1.5k
  • 98
  • 4.9k

sql cte to join two results in one common

Feb 26 2019 2:13 AM
;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)