i want to avoid "??" in the result set but i am getting "??"
can you please help on this.
insert INTO #AllCountryStates
select * from #AllCountryStates
declare @Country NVARCHAR(1000)
SELECT @Country = STUFF(
(SELECT ',' + ''
+ ( CountryName ) + ''
FROM (select c.CountryName,c.TreeId
FROM #AllCountryStates c
) as CountryName order by TreeId
FOR XML PATH(''), TYPE).value('.', 'VARCHAR(MAX)'),1,1,'' )
- This topic was modified 2 months ago by kbhanu15.