How to load the data into new table by getting sql server cpu utilization result data?

Question

Hi, could somebody help me to solve, How to load the following data, which got from cpu utilization sql query into new table.

Thanks in advance!

Answer 1

To create a new table:

SELECT TOP(@lastNmin)
   SQLProcessUtilization AS [SQLServer_CPU_Utilization],
   . . .
into MyNewTable
FROM (SELECT record.value . . .

Use the #MyNewTable name to create a temporary table.

If the table already exists:

insert MyTable
SELECT TOP(@lastNmin)
   SQLProcessUtilization AS [SQLServer_CPU_Utilization],
. . .