set @sqlstr1='select f.* into ##ttt from ('+@sqlstr+') f' EXECUTE SP_EXECUTESQL @sqlstr1 select @DataCount=count(*) from ##ttt