Sql Query Dynamic

Hi Ramco Ramco,

You can get your desired result with following query by concating two columns:

DECLARE @data TABLE
(
   Column1 int,
   Column2 int,
   Column3 varchar(50),
   Column4 varchar(50),
   Column5 varchar(50),
   Column6 varchar(50),
   Column7 varchar(50),
   Column8 varchar(50)
)
                                                       

INSERT INTO @data (Column1, Column2, Column3, Column4, Column5, Column6, Column7, Column8) 
VALUES (209, 100, 'Sudhir kumar Gupta', '30 days', 'Davinder singh', '1 Day', 'Karan Negi', '10 days')

SELECT * FROM @data

select Column1 as 'No', Column2 as 'Total Days', Column3 + ' - ' + Column4 as 'Level 1', Column5 + ' - ' + Column6 as 'Level 2', Column7 + ' - ' + Column8 as 'Level 3' from @data

Hope, this will help you!