<div>
Wait. &nbsp;Is the OP asking for a dynamic way to create a temp table based on 1 view ? &nbsp; That's how I read it. &nbsp;If that's not the case, then please disregard my earlier answer.
</div>


<div>
Hmm .. looks like we'll need a clarification, as I interpreted it as multiple views, which after a second reading may not be correct.
</div>


<div>
Thanks for all the posts!<br />
<br />
After rereading my question I realized I was indeed unclear<br />
<br />
I wanted to give at least some points to all posts<br />
<br />
Ultimately scott's suggestion is the one I went with so I give him the most
</div>


<div>
<div class="content wysiwyg-content">
I have a stored procedure in which I need to create a single temp table based on one of several views<br />
<br />
Each of the views has a differing amount of fields<br />
<br />
I will use this table to turn around and &nbsp;generate a csv file<br />
<br />
Is there a way to put the view name into a variable and use that variable value to create the temp table?
</div>
</div>


I have a stored procedure in which I need to create a single temp table based on one of several views

Each of the views has a differing amount of fields

I will use this table to turn around and  generate a csv file

Is there a way to put the view name into a variable and use that variable value to create the temp table?

Wait.  Is the OP asking for a dynamic way to create a temp table based on 1 view ?   That&#39;s how I read it.  If that&#39;s not the case, then please disregard my earlier answer.

Hmm .. looks like we&#39;ll need a clarification, as I interpreted it as multiple views, which after a second reading may not be correct.

Thanks for all the posts!

After rereading my question I realized I was indeed unclear

I wanted to give at least some points to all posts

Ultimately scott&#39;s suggestion is the one I went with so I give him the most

Create temp table using dynamic sql

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.

Microsoft SQL Server

Microsoft SQL Server 2008 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. Major improvements include the  Always On technologies and support for unstructured data types.