Hello,
Raked my brain for an hour and I cant get this going. Given the following data I want to flatten it to one row and get the following
--"ሀ": "ha", "ሁ": "hhu", "ሂ": "hhi"
declare @unicodeblock table(unicodevalue nchar(1), syllable varchar(10))
insert into @unicodeblock
select N'ሀ', 'ha' union
select N'ሁ', 'hhu' union
select N'ሂ', 'hhi'
Thanks!