26 Jun 2013 by damodara naidu betha
Hi try this code block DECLARE @tmp TABLE ([Parent Number] BIGINT, SNDDI VARCHAR(255), DDI VARCHAR(255)) INSERT INTO @tmp ([Parent Number], SNDDI, DDI) SELECT 12457847549 AS [Parent Number],'24578487557,5559864127' AS SNDDI,'' AS DDI UNION ALL SELECT 54876458722, '',...