Hey SSCarpal Tunnel !

I want the output in variable @Q_Id as Id ; Question_id | Id ; Question_id|

and right noe m getting null in the variable .

I tried :

set @table_query='SELECT @id= [ID] , @q_id=[Question_ID] FROM ['+@table+'] WHERE [Section_ID]='+CONVERT(varchar(50),@sec_id)

EXEC(@table_query)

@Q_Id=@Q_id + '|' + @id + ';' + @q_id

but it gives NULL value