How to store the result set in temp table

[rsrinivasan]

Hi all,

When i run below statement, i get some result set. But i want to store the results sets in some temp table. How can i store it?

DBCC SHOWCONTIG ('table_name') WITH TABLERESULTS

Thanks,

[ck9663]

You might need to get the info you need from one of the system tables or system views.

-- CK

[rsrinivasan]

You might need to get the info you need from one of the system tables or system views.

-- CK

So what to do for this to store this result in some temp table. I do not have any idea to implement this. please suggest some way to do this.

[JinxT]

Hi,

Take a look at this link :
http://www.sqlservercentral.com/Forums/Topic550007-5-1.aspx

J.

[ck9663]

JinxT is right, it can be done :)

Check sample E from here

specifically, the lines:

BEGIN
-- Do the showcontig of all indexes of the table
   INSERT INTO #fraglist 
   EXEC ('DBCC SHOWCONTIG (''' + @tablename + ''') 
      WITH FAST, TABLERESULTS, ALL_INDEXES, NO_INFOMSGS')
   FETCH NEXT
      FROM tables
      INTO @tablename
END

-- CK

[rsrinivasan]

JinxT is right, it can be done :)

Check sample E from here

specifically, the lines:

BEGIN
-- Do the showcontig of all indexes of the table
   INSERT INTO #fraglist 
   EXEC ('DBCC SHOWCONTIG (''' + @tablename + ''') 
      WITH FAST, TABLERESULTS, ALL_INDEXES, NO_INFOMSGS')
   FETCH NEXT
      FROM tables
      INTO @tablename
END

-- CK

Thanks for it. It is working fine.