<div>
<br />
Try the Below Query.. so use this as an Outer query to get the desired results..Replace the Table Name with your query like <br />
<br />
Select .... FROM ()X <br />
Group By ...<br />
<br />
<br />
<br />
SELECT Customer, MAX(Sell_date) as Sell_Date, SUM(Parts) as Parts , SUM(Labour) as Labour, Max(Pay_Date) as Pay_Date <br />
FROM TableName<br />
GROUP BY Customer
</div>



Try the Below Query.. so use this as an Outer query to get the desired results..Replace the Table Name with your query like

Select .... FROM ()X
Group By ...



SELECT Customer, MAX(Sell_date) as Sell_Date, SUM(Parts) as Parts , SUM(Labour) as Labour, Max(Pay_Date) as Pay_Date
FROM TableName
GROUP BY Customer

<div>
<div class="content wysiwyg-content">
I have a query which, through joins and such, produces sort of the correct results. &nbsp;The problem is that it produces two rows.<br />
<br />
The results are something list this
<pre><code id="code-10-27029859-1">Customer  Sell_Date  Parts  Labour  Pay_Date
12345678  05-30-11   12.34  50.00
12345678             24.56  12.50   06-02-11
98765432  05-22-11   18.23  12.50
98765432             16.19  32.00   05-26-11</code></pre>
<br />
I want to merge th rows so that I have an output like this:
<pre><code id="code-10-27029859-2">Customer  Sell_Date  Parts  Labour  Pay_Date
12345678  05-30-11   36.90  62.50   06-02-11
98765432  05-22-11   34.42  44.50   05-26-11</code></pre>
<br />
I know how to do it with the numbers, but how do I get the dates to merge?
</div>
</div>


I have a query which, through joins and such, produces sort of the correct results.  The problem is that it produces two rows.

The results are something list this(CODE)

I want to merge th rows so that I have an output like this:(CODE)

I know how to do it with the numbers, but how do I get the dates to merge?

Combining Rows

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.