DECLARE @CITY NVARCHAR(MAX)
SELECT @CITY = COALESCE(@CITY+',','')+CITY_NAME FROM MST_CITY
SELECT @CITY
-- RESULT
KOLHAPUR,SANGALI,MUMBAI,PUNE
SELECT @CITY = COALESCE(@CITY+',','')+CITY_NAME FROM MST_CITY
SELECT @CITY
-- RESULT
KOLHAPUR,SANGALI,MUMBAI,PUNE
Comments
Post a Comment