SQL Server dynamically generates temporary tables

If object_id ('[tmp_processinfo]') is not null drop table [tmp_processinfo] Create Table tmp_processinfo (finterid int, fname varchar (255) -- insert tmp_processinfo -- select 0, 'A' Union all -- select 1, 'B' -- select * From tmp_processinfodeclare @ querystr varchar (255), @ SQL varchar (1000) set @ querystr = 'and FTYPE = 0 and fprocessinfoid in (122,150,)' set @ querystr = Replace (@ querystr, 'and FTYPE = 0 ','') set @ querystr = Replace (@ querystr, 'fprocessinfoid', 'finterid') set @ SQL = 'insert tmp_processinfo select finterid, fname from t_cy_processinfo where 1 = 1' + @ querystrset @ SQL = @ SQL + 'Union all select 0, ''' print @ sqlinsert tmp_processinfo select finterid, fname from t_cy_processinfo where 1 = 1 and finterid in (0, 53, 122,150) Union all select 0, ''select * From tmp_processinfo