<div>
It did not solve the Problem, as my question is as follows<br />
<br />
I have the &nbsp;Partioning table &nbsp;which contains the data of Year 2005 and 2006 , now i want to get &nbsp;data of few columns from year 2005 and another few columns data from 2006 year, so how can i fire a query on the single table?<br />
whether i need to use two queries to fire at a time ?
</div>


<div>
<div class="content wysiwyg-content">
Hi<br />
<br />
I have the &nbsp;Partioning table &nbsp;which contains the data of Year 2005 and 2006 , now i want to get &nbsp;data of few columns from year 2005 and another few columns data from 2006 year, so how can i fire a query on the single table, whether i need to fire the two queries or is ther any way.<br />
<br />
Please suggest.
</div>
</div>


Hi

I have the  Partioning table  which contains the data of Year 2005 and 2006 , now i want to get  data of few columns from year 2005 and another few columns data from 2006 year, so how can i fire a query on the single table, whether i need to fire the two queries or is ther any way.

Please suggest.

It did not solve the Problem, as my question is as follows

I have the  Partioning table  which contains the data of Year 2005 and 2006 , now i want to get  data of few columns from year 2005 and another few columns data from 2006 year, so how can i fire a query on the single table?
whether i need to use two queries to fire at a time ?

Query on Partioning Table.

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.