Rehaan Ahmed

Rehaan Ahmed

  • 1.7k
  • 86
  • 896

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)