create table from USP output - How to do it?

Question

create table from USP output - How to do it?

Tobar

SSCarpal Tunnel

Points: 4876
More actions
October 31, 2011 at 12:27 pm

#245426

Is there a way to make the following thing happen in SQL:
@Str = 'USP parm1, parm2'
select *
into BLAH
Exec (@Str)
I know you can do:
insert into BLAH
Exec (@Str)
but I am trying to create the table BLAH from the output instead of needing to have the table defined before hand.
Thanks.
<><
Livin' down on the cube farm. Left, left, then a right.

Viewing 4 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

Sean Lange SSC Guru Points: 286602 More actions · Answer 1

You could do it with openrowset but it would be rather ugly. It is usually easier to just create the table first. Here is a link from a discussion today doing the very same thing.

http://www.sqlservercentral.com/Forums/Topic1198143-338-1.aspx

_______________________________________________________________

Need help? Help us help you.

Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.

Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.

Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/

SQLRNNR SSC Guru Points: 281334 More actions · Answer 2

I agree with Sean, it is so much cleaner to define the table first.

Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events

Tobar SSCarpal Tunnel Points: 4876 More actions · Answer 3

Thanks.

<><
Livin' down on the cube farm. Left, left, then a right.

create table from USP output - How to do it?

Cookies on SQLServerCentral