SweatCoder
asked on
capture xp_msver results into temp table
How can I get the results of a system proc into a temp table? I tried this, but it breaks:
select xp_msver Language
into #junk
Yet if you run "xp_msver Language" by itself, it works fine and returns 1 record with a few columns.
select xp_msver Language
into #junk
Yet if you run "xp_msver Language" by itself, it works fine and returns 1 record with a few columns.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SweatCoder,
> Invalid object name '#temp'.
Did you include the first "Creata table " statement also
> I was thinking SELECT INTO because that auto-creates the table.
You can't do this, you need to create the table first
> Invalid object name '#temp'.
Did you include the first "Creata table " statement also
> I was thinking SELECT INTO because that auto-creates the table.
You can't do this, you need to create the table first
ASKER
Sorry, I had missed the 1st line, was in a hurry. :-)
Works great.
Works great.
ASKER
I was thinking SELECT INTO because that auto-creates the table.