<div>
Here you can use Group By clause in SQL to combine result, you can apply group by on selected columns
</div>


Here you can use Group By clause in SQL to combine result, you can apply group by on selected columns

<div>
Grouping doesn't work for me in this scenario, at least not that I can tell. &nbsp;Do you have a query in mind?
</div>


Grouping doesn't work for me in this scenario, at least not that I can tell.  Do you have a query in mind?

<div>
SELECT name, id1, id2, MAX(buyout1) AS buyout1, MAX(buyout2) AS buyout2, MAX(buyout3) &nbsp;AS buyout3<br />
FROM ...<br />
GROUP BY name, id1, id2<br />
<br />
<br />
Corresponds to sample data like this:<br />
name = Broward County<br />
id1 = 07DB-3V-11-16-01-Z 08<br />
id2 = 596000531<br />
buyout1 = Buyouts<br />
buyout2 = Null<br />
buyout3 = Null<br />
...<br />
buyout1 = Null<br />
buyout2 = Null<br />
buyout3 = Buyouts
</div>


SELECT name, id1, id2, MAX(buyout1) AS buyout1, MAX(buyout2) AS buyout2, MAX(buyout3)  AS buyout3
FROM ...
GROUP BY name, id1, id2


Corresponds to sample data like this:
name = Broward County
id1 = 07DB-3V-11-16-01-Z 08
id2 = 596000531
buyout1 = Buyouts
buyout2 = Null
buyout3 = Null
...
buyout1 = Null
buyout2 = Null
buyout3 = Buyouts

<div>
I resolved it, I inserted the results into a Temp table then joined on itself.
</div>


I resolved it, I inserted the results into a Temp table then joined on itself.

<div>
<div class="content wysiwyg-content">
I have a query that is returning the following data. &nbsp;<br />
<br />
Broward County &nbsp; &nbsp; 07DB-3V-11-16-01-Z 08 &nbsp; 596000531 &nbsp; &nbsp;Buyouts &nbsp; &nbsp;Null &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Null<br />
Broward County &nbsp; &nbsp; 07DB-3V-11-16-01-Z 08 &nbsp; 596000531 &nbsp; &nbsp;Null &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Null &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Buyouts<br />
<br />
I would like to group it up to just show one line that looks like :<br />
<br />
Broward County &nbsp; &nbsp; 07DB-3V-11-16-01-Z 08 &nbsp; 596000531 &nbsp; &nbsp;Buyouts &nbsp; &nbsp; Null &nbsp; &nbsp; Buyouts<br />
<br />
Thanks in advance.
</div>
</div>


I have a query that is returning the following data.  

Broward County     07DB-3V-11-16-01-Z 08   596000531    Buyouts    Null          Null
Broward County     07DB-3V-11-16-01-Z 08   596000531    Null          Null          Buyouts

I would like to group it up to just show one line that looks like :

Broward County     07DB-3V-11-16-01-Z 08   596000531    Buyouts     Null     Buyouts

Thanks in advance.

sql server query grouping

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.