<div>
<div class="content wysiwyg-content">
Hi,<br />
we have created a view that shows info from many different tables joined together. the output look like this<br />
SELECT * from view_Analysts<br />
AS-IS result:<br />
id &nbsp;date &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;analyst &nbsp;type &nbsp; &nbsp; <br />
1 &nbsp; 10/10/2009 &nbsp; Smith &nbsp; &nbsp; Lunch &nbsp;<br />
1 &nbsp; 10/10/2009 &nbsp; Hall &nbsp; &nbsp; &nbsp; &nbsp;Lunch &nbsp;<br />
2 &nbsp; 12/11/2009 &nbsp; Smith &nbsp; &nbsp; Lunch <br />
3 &nbsp; 13/11/2009 &nbsp; Jackson Group<br />
3 &nbsp; 13/11/2009 &nbsp; Harris &nbsp; &nbsp; Group<br />
<br />
TO-BE result<br />
id &nbsp;date &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;analyst &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;type<br />
1 &nbsp; 10/10/2009 &nbsp; Smith+Hall &nbsp; &nbsp; &nbsp; &nbsp; Lunch<br />
2 &nbsp; 12/11/2009 &nbsp; Smith &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Lunch<br />
3 &nbsp; 13/11/2009 &nbsp; Jackson+Harris Group<br />
<br />
When all columns, except analyst, is the same, then mergethe two rows into one row with a '+' sign in analyst column<br />
<br />
How can I write my sql to get TO-BE output?
</div>
</div>


Hi,
we have created a view that shows info from many different tables joined together. the output look like this
SELECT * from view_Analysts
AS-IS result:
id  date              analyst  type     
1   10/10/2009   Smith     Lunch  
1   10/10/2009   Hall        Lunch  
2   12/11/2009   Smith     Lunch 
3   13/11/2009   Jackson Group
3   13/11/2009   Harris     Group

TO-BE result
id  date              analyst              type
1   10/10/2009   Smith+Hall         Lunch
2   12/11/2009   Smith                 Lunch
3   13/11/2009   Jackson+Harris Group

When all columns, except analyst, is the same, then mergethe two rows into one row with a '+' sign in analyst column

How can I write my sql to get TO-BE output?

Merge two rows in SQL

Hi,
we have created a view that shows info from many different tables joined together. the output look like this
SELECT * from view_Analysts
AS-IS result:
id  date              analyst  type     
1   10/10/2009   Smith     Lunch  
1   10/10/2009   Hall        Lunch  
2   12/11/2009   Smith     Lunch 
3   13/11/2009   Jackson Group
3   13/11/2009   Harris     Group

TO-BE result
id  date              analyst              type
1   10/10/2009   Smith+Hall         Lunch
2   12/11/2009   Smith                 Lunch
3   13/11/2009   Jackson+Harris Group

When all columns, except analyst, is the same, then mergethe two rows into one row with a &#39;+&#39; sign in analyst column

How can I write my sql to get TO-BE output?

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.

Microsoft SQL Server 2008

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.