CREATE Procedure [dbo].[Tbl_SP_GetVotercationData]        
(        
 @Race Varchar(50),        
 @Zcode Int        
)        
As        
Begin        
 Declare @colnames varchar(max),        
 @result varchar(max),        
 @delqry varchar(500)        
        
 set @delqry = 'Drop table Tbl_TempVoterData'        
         
 IF OBJECT_ID ('MyDB.dbo.Tbl_TempVoterData','U') IS NOT NULL        
 Exec(@delqry)     
  
 If(@Race) is not null     
 Begin  
 select @colnames = stuff((select ', '+ column_name from information_schema.columns where table_name = 'Tbl_VoterData'        
        and column_name like @Race +'%' and column_name <> @Race +'Income' and column_name <> 'Zipcode' for xml path('')),1,1,'')         
        
 If (@colnames) is not null    
  exec('select Zipcode, '+@colnames+' into Tbl_TempVoterData from Tbl_VoterData where Zipcode = ' + @Zcode)        
 End   
End   

SELECT TOP 1000
     a.last_execution_time, 
     cast(last_elapsed_time/1000000.0 as decimal(10, 3)) Last_Elasped_Seconds,
	 Object_Name(ObjectID) Object_Name,
	 DB_Name(dbID) Database_Name,
     SUBSTRING(b.text, (a.statement_start_offset/2) + 1,      
     ((CASE statement_end_offset           WHEN -1 THEN DATALENGTH(b.text)          ELSE a.statement_end_offset END
               - a.statement_start_offset)/2) + 1) AS statement_text,               
     total_worker_time as CPU_time, 
     *    
FROM 
     sys.dm_exec_query_stats a  CROSS APPLY 
     sys.dm_exec_sql_text (a.sql_handle) AS b  
WHERE 
     last_execution_time > '2009-11-16 0:00'   -- Filter by Time
ORDER BY 
     a.last_execution_time desc

quote:

---

In ANY case

LOSE THE DYNAMIC SQL

---

quote:

---

Originally posted by DonAtWork

return all columns except? so, run the query set based, non dynamic, as a subquery, and just select the columns you want to send back to the .net application.

---