<div>
... or use angelIII's approach to bolt them all together...
</div>


... or use angelIII's approach to bolt them all together...

<div>
Thanks guys. <br />
That's a real help...<br />
<br />

</div>


<div>
cheers bud. My first poinx for about a year :)<br />

</div>


cheers bud. My first poinx for about a year :)


<div>
<div class="content wysiwyg-content">
I have two tables with the same column. The second was created using select * into &lt;tableb&gt; from &lt;tablea&gt; where amount x &gt;&nbsp;y dollars<br />
<br />
I would like to append tableb with another set of information from table a with another condition (ie colx &gt;&nbsp;const y). &nbsp;I can't just compound it intot the same where statement as the result sets are not mutually exclusive<br />
<br />
eg for an item in the table worth 10000 dollars, it would be selected on a filter for &gt;1000 and &gt;5000 dollars, so it should appear twice in table b.<br />
<br />
One way might be to use inserts but there's a lot of columns, and the column list changes fairly frequently so I don't want to have to specify each column individually.<br />
<br />
Is there a simpler way of appending the data from several queries in a single table?<br />

</div>
</div>


I have two tables with the same column. The second was created using select * into <tableb> from <tablea> where amount x > y dollars

I would like to append tableb with another set of information from table a with another condition (ie colx > const y).  I can't just compound it intot the same where statement as the result sets are not mutually exclusive

eg for an item in the table worth 10000 dollars, it would be selected on a filter for >1000 and >5000 dollars, so it should appear twice in table b.

One way might be to use inserts but there's a lot of columns, and the column list changes fairly frequently so I don't want to have to specify each column individually.

Is there a simpler way of appending the data from several queries in a single table?


Can I append a table with all fields from another table.

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.