<div>
thanks for correcting me.<br />
<br />
it should be total instead of 1.
</div>


thanks for correcting me.

it should be total instead of 1.

<div>
I used the pivot function under 2005 in the end<br />
<br />
PIVOT (<br />
SUM(TOTAL) FOR ONLINEORDER IN ([N],[Y])<br />

</div>


I used the pivot function under 2005 in the end

PIVOT (
SUM(TOTAL) FOR ONLINEORDER IN ([N],[Y])


<div>
<div class="content wysiwyg-content">
Hi, <br />
<br />
I have a table with the folowing structure <br />
OrderDate &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Total &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Online<br />
2/10/2007 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;1 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Y<br />
2/10/2007 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;1 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;N<br />
<br />
Is it posible to convert it into the following in a single statement?<br />
OrderDate &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Online &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;OffLine<br />
2/10/2007 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;1 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;1<br />

</div>
</div>


Hi, 

I have a table with the folowing structure 
OrderDate	Total	Online
2/10/2007	1	Y
2/10/2007	1	N

Is it posible to convert it into the following in a single statement?
OrderDate	Online	OffLine
2/10/2007	1	1


Pivot Sql statement

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.