INSERT TO TEMP TABLE FROM A DYNAMIC QUERRY

INSERT TO TEMP TABLE FROM A DYNAMIC QUERRY

declare @query varchar(200)

set @query='SELECT      1 as NO,

                                      ''Madhan'' as Name '

insert into #temp (No,Name)

exec (@query)