how to separate the mem into another column

• Mad-Dog

  SSCertifiable

  Points: 6117

  More actions

  April 12, 2010 at 8:04 am

  #139349

  Hi,

  i've this script that insert all "tasklist" into a table.

  i want that the Image Name will be in one column and the Mem Usage will be in another column but the Image Name next to the Mem Usage.

  How i do that?

  THX

  declare @tasklist table (taskname nvarchar (500))

  insert into @tasklist

  exec xp_cmdshell 'tasklist /fo list'

  delete from @tasklist where taskname IS NULL or taskname like 'Session Name:%' or taskname like 'Session#%' or taskname like 'PID:%'

  select * from @tasklist

• Richard M.

  SSCertifiable

  Points: 7401

  More actions

  April 12, 2010 at 10:05 am

  #1150151

  You should probably just leave the default format and pick out the columns you need:

  DECLARE @tasklist TABLE (taskname NVARCHAR (500))

  INSERT INTO @tasklist

  EXEC xp_cmdshell 'tasklist'

  DELETE FROM @tasklist WHERE taskname IS NULL OR taskname = 'Image Name' OR taskname LIKE '%Mem Usage' OR taskname LIKE '===%'

  SELECT

  LEFT(taskname,25) AS 'Image Name'

  ,LTRIM(RTRIM(RIGHT(taskname,12))) AS 'Mem Usage'

  FROM

  @tasklist

  _______________________________________________________________________
  For better assistance in answering your questions, click here[/url]