<div>
Please post the column names<br />

<pre><code id="code-20-41962740-1">SELECT 
   Val1,
   Val2,
   Val3,
   (Val1 + Val2 + Val3) as 'Total'
FROM Emp</code></pre>
</div>


Please post the column names


SELECT 
   Val1,
   Val2,
   Val3,
   (Val1 + Val2 + Val3) as 'Total'
FROM Emp

<div>
Can you please provide few rows ?
</div>


<div>
Customer ID<br />
DateOfOrder<br />
AmountOfOrder<br />
<br />
are the columns names I am working with.
</div>


Customer ID
DateOfOrder
AmountOfOrder

are the columns names I am working with.

<div>
<div class="content wysiwyg-content">
I need a query that shows how much each customer has ordered for the last 8 weeks, and the week dates are the columns.<br />
<br />
Something Like<br />
<br />
Customer ID &nbsp;11/27/2016 &nbsp; 12/4/2016 &nbsp; 12/11/2016 &nbsp;12/18/2016..........<br />
124355 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $48.50 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;$156.00 &nbsp; &nbsp;$25.00 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $32.00<br />
<br />
The total for the week is a sum of all orders for that week.<br />
<br />
what is the easiest way to do this ?<br />
<br />
Thanks
</div>
</div>


I need a query that shows how much each customer has ordered for the last 8 weeks, and the week dates are the columns.

Something Like

Customer ID  11/27/2016   12/4/2016   12/11/2016  12/18/2016..........
124355               $48.50            $156.00    $25.00             $32.00

The total for the week is a sum of all orders for that week.

what is the easiest way to do this ?

Thanks

ms sql last 8 weeks as columns

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.

Microsoft SQL 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.