<div>
I don't even know what I'm talking about.<br />
Got confused asking this question ...<br />
What I was doing was selecting from table a certain criteria - <br />
then I did an insert query using data from first query going row by row - <br />
knew this seemed inefficient ..<br />
I'm on my first cup of coffee - rough night ...<br />
As soon as I read your response I said &quot;Idiot!&quot;<br />
I just need to insert and select using the criteria from the first query - eliminating the first query altogether.<br />
easy as cake<br />
thanks for pointing this out and I won't post again until I'm on second cup (of coffee)
</div>


I don't even know what I'm talking about.
Got confused asking this question ...
What I was doing was selecting from table a certain criteria -
then I did an insert query using data from first query going row by row -
knew this seemed inefficient ..
I'm on my first cup of coffee - rough night ...
As soon as I read your response I said "Idiot!"
I just need to insert and select using the criteria from the first query - eliminating the first query altogether.
easy as cake
thanks for pointing this out and I won't post again until I'm on second cup (of coffee)

<div>
<div class="content wysiwyg-content">
Hi,<br />
I'm wondering if there is a way to select rows that match a criteria and copy back into the same table.<br />
All copied data would be the same as the original except for 2 columns which would then be specified.<br />
thanks
</div>
</div>


Hi,
I'm wondering if there is a way to select rows that match a criteria and copy back into the same table.
All copied data would be the same as the original except for 2 columns which would then be specified.
thanks

select into same table syntax

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.