hhnetworks

<div>
Thanks! &nbsp;I only have Read Only access to the remote server, so cant use an SP on it. &nbsp;The INSERT INTO is working.
</div>


Thanks!  I only have Read Only access to the remote server, so cant use an SP on it.  The INSERT INTO is working.

<div>
<div class="content wysiwyg-content">
I have a query that Im running against a linked server. Due to the 8000 character limit of Openquery, I am using dynamic SQL:<br />

<pre><code id="code-10-29164613-1">DECLARE @SQL1 VARCHAR(MAX)
SET @SQL1 = '&lt;huge select query&gt;'
EXECUTE (@SQL1) AT LinkedServer</code></pre>
How do I &quot;SELECT * INTO &lt;Table&gt;&quot; on my local server?
</div>
</div>


I have a query that Im running against a linked server. Due to the 8000 character limit of Openquery, I am using dynamic SQL:
(CODE)
How do I "SELECT * INTO <Table>" on my local server?

Dynamic SQL query from Linked Server

SQL (Structured Query Language) is designed to be used in conjunction with relational database products as of a means of working with sets of data. SQL consists of data definition, data manipulation, and procedural elements. Its scope includes data insert, query, update and delete, schema creation and modification, and data access control.