try this:

    SELECT ReportId, Email = 
        STUFF((SELECT &#39;, &#39; + Email
               FROM your_table b 
               WHERE b.ReportId = a.ReportId 
              FOR XML PATH(&#39;&#39;)), 1, 2, &#39;&#39;)
    FROM your_table a
    GROUP BY ReportId

&lt;br&gt;
#[SQL fiddle demo][1]


  [1]: http://sqlfiddle.com/#!3/0c7d6/2

    SELECT  [ReportId], 
    		SUBSTRING(d.EmailList,1, LEN(d.EmailList) - 1) EmailList
    FROM
    		(
    			SELECT DISTINCT [ReportId]
    			FROM Table1
    		) a
    		CROSS APPLY
    		(
    			SELECT [Email] + &#39;, &#39; 
    			FROM Table1 AS B 
    			WHERE A.[ReportId] = B.[ReportId]
    			FOR XML PATH(&#39;&#39;)
    		) D (EmailList) 

#[SQLFiddle Demo](http://sqlfiddle.com/#!18/3192a/1)

I&#39;ve been looking around recently into Rails and notice that there are a lot of references to `current_user`. Does this only come from Devise? and do I have to manually define it myself even if I use Devise? Are there prerequisites to using `current_user` (like the existence of sessions, users, etc)?

Rails: where does the infamous &quot;current_user&quot; come from?

Is it necessary to have git repo on openshift only? I already have bitbucket / github git repo and would prefer to push there only. Can I simply hook into it so that openshift gets intimation ?

Or for simplification, I push only at github, but when I want to deploy, I do something with openshift?

I did check [this](https://openshift.redhat.com/community/kb/kb-e1006-sync-new-git-repo-with-your-own-existing-git-repo) but it confused me:  it&#39;s talking about merging exiting and new (openshift) git ?

Can I use my existing git repo with openshift?

&gt; **Possible Duplicate:**  
&gt; [SQL group_concat function in SQL Server](https://stackoverflow.com/questions/8868604/sql-group-concat-function-in-sql-server)  

&lt;!-- End of automatically inserted text --&gt;

I am looking to create a query but somehow I am unable to do so. Can anyone please help me out here?

The original data

    ID    ReportId     Email
    1     1            a@a.com
    2     2            b@b.com
    3     1            c@c.com
    4     3            d@d.com
    5     3            e@e.com

I want to group by `ReportId`, but all the email should be comma separated. So the result should be:

    ReportId     Email
    1            a@a.com, c@c.com
    2            b@b.com
    3            d@d.com, e@e.com

What is the best way to do this? 

I am trying the group by clause but if there is any other thing then i am open to implement that also. I really appreciate your time and help on this. Thank you.



SQL Server : GROUP BY clause to get comma-separated values

> Possible Duplicate: 
> <a href="https://stackoverflow.com/questions/8868604/sql-group-concat-function-in-sql-server" target="_blank" rel="noopener noreferrer">SQL group_concat function in SQL Server</a>

I am looking to create a query but somehow I am unable to do so. Can anyone please help me out here?
The original data
<pre><code class="hljs language-java">ID ReportId Email
1 1 a@a.com
2 2 b@b.com
3 1 c@c.com
4 3 d@d.com
5 3 e@e.com
</code></pre>
I want to group by <code>ReportId</code>, but all the email should be comma separated. So the result should be:
<pre><code class="hljs language-java">ReportId Email
1 a@a.com, c@c.com
2 b@b.com
3 d@d.com, e@e.com
</code></pre>
What is the best way to do this?
I am trying the group by clause but if there is any other thing then i am open to implement that also. I really appreciate your time and help on this. Thank you.

I am not deeply acquainted with Oracle Sql Queries, therefore I face a problem on deleting some rows from a table which must fulfill a constraint which includes fields of another (joining) table. In other words I want to write a query to delete rows including JOIN. 

In my case I have a table `ProductFilters` and another table `Products` joined on fields `ProductFilters.productID = Products.ID`. I want to delete the rows from `ProductFilters` having an `ID` higher or equal to 200 and the product they refer has the name &#39;Mark&#39; (name is a field in Product).

I would like to be informed initially if JOIN is acceptable in a Delete Query in Oracle. If not how should I modify this Query in order to make it work, since on that form I receive an error:

    DELETE From PRODUCTFILTERS pf 
    where pf.id&gt;=200 
    And pf.rowid in 
    (
         Select rowid from PRODUCTFILTERS 
         inner join PRODUCTS on PRODUCTFILTERS.PRODUCTID = PRODUCTS.ID 
         And PRODUCTS.NAME= &#39;Mark&#39;
    );       

Delete with &quot;Join&quot; in Oracle sql Query

I&#39;m working with SQL Server 2008 and I can&#39;t seem to do drop and create a database.

I&#39;ve tried a few different ways but I always end up failing to drop or trying to &quot;use&quot; before it seems to be created.

My current attempt looks like this.

    use master;
    GO
    IF EXISTS (SELECT name FROM master.dbo.sysdatabases WHERE name = N&#39;test&#39;)
    BEGIN
    DROP DATABASE [test];
    END
    GO
    CREATE DATABASE [test];
    GO
    use [test];
    GO
    
The `GO` were suggested on a MS forum as a way to stop some issues that occur when selecting databases.

With this I currently get the output (with a ore existing database of the same name) of:

&gt; Msg 3702, Level 16, State 4, Line 3  
&gt; Cannot drop database &quot;test&quot; because it is currently in use.  
&gt; Msg 1801, Level 16, State 3, Line 1  
&gt; Database &#39;test&#39; already exists. Choose a different database name.  
&gt; Msg 2714, Level 16, State 6, Line 2  
&gt; There is already an object named &#39;staff_type&#39; in the database.

With the last 2 lines repeated for every table in my database.

unable to drop and create database in sql server

I have this code for query: 

    $repository = $em-&gt;getRepository(&#39;AcmeCrawlerBundle:Trainings&#39;);
           $query = $repository-&gt;createQueryBuilder(&#39;p&#39;)
                   -&gt;where(&#39;p.title LIKE :word&#39;)
                   -&gt;orWhere(&#39;p.discription LIKE :word&#39;)
                   -&gt;setParameter(&#39;word&#39;, $word)
                   -&gt;getQuery();
    $trainings = $query-&gt;getResult();

The problem is: even if matches exist, they not found by this query. I used this code to see full sql: 

    print_r(array(
            &#39;sql&#39;        =&gt; $query-&gt;getSQL(),
            &#39;parameters&#39; =&gt; $query-&gt;getParameters(),
            ));

And what I&#39;ve got:

    FROM Trainings t0_ WHERE t0_.title LIKE ? OR t0_.discription LIKE ? [parameters] =&gt; Array ( [word] =&gt; Spoken ) 
(last part of query)
Tell me please what to change?

Doctrine 2 Query with LIKE

I already have a function in SQL Server 2005 as:

    ALTER function [dbo].[fCalculateEstimateDate] (@vWorkOrderID numeric)
    Returns varchar(100)  AS
    Begin
      &lt;Function Body&gt;
    End

I want to modify this function to accept addition optional parameter @ToDate. I am going to add logic in function if @Todate Provided then do something else continue with existing code.

I modified the function as:

    ALTER function [dbo].[fCalculateEstimateDate] (@vWorkOrderID numeric,@ToDate DateTime=null)
    Returns varchar(100)  AS
    Begin
      &lt;Function Body&gt;
    End

Now I can call function as:

    SELECT dbo.fCalculateEstimateDate(647,GETDATE())

But it gives error on following call:

    SELECT dbo.fCalculateEstimateDate(647)

as

&gt; An insufficient number of arguments were supplied for the procedure or
&gt; function dbo.fCalculateEstimateDate.

which as per my understanding should not happen.

Am I missing anything?
Thanks in advance.

Alter a SQL server function to accept new optional parameter

MySQL very slow for alter table query

I have an column with email in table `customer` where the data in the column contains special character: TAB

When I do a select, I need to remove the TAB space from that column.

Means there is an empty TAB space followed by the **EmailID:     xyz.com**

I tried using the `LTRIM` and `RTRIM` but that does not work here.


How eliminate the tab space in the column in SQL Server 2008

I want to insert a `datetime` value into a table(SQL Server) using the sql query below
    
    insert into table1(approvaldate)values(18-06-12 10:34:09 AM);

But I get this Error msg. `Incorrect syntax near &#39;10&#39;.`

I tried it with the quotes

    insert into table1(approvaldate)values(&#39;18-06-12 10:34:09 AM&#39;);

I get this error message `Cannot convert varchar to datetime`

Kindly help! 
Thanks.


Sql query to insert datetime in SQL Server

I need to run a select statement that returns all rows where the value of a column is not distinct (e.g. EmailAddress).

For example, if the table looks like below:

    CustomerName     EmailAddress
    Aaron            aaron@gmail.com
    Christy          aaron@gmail.com
    Jason            jason@gmail.com
    Eric             eric@gmail.com
    John             aaron@gmail.com

I need the query to return:

    Aaron            aaron@gmail.com
    Christy          aaron@gmail.com
    John             aaron@gmail.com

I have read many posts and tried different queries to no avail.  The query that I believe should work is below.  Can someone suggest an alternative or tell me what may be wrong with my query?

    select EmailAddress, CustomerName from Customers
    group by EmailAddress, CustomerName
    having COUNT(distinct(EmailAddress)) &gt; 1

How to Select Every Row Where Column Value is NOT Distinct

I&#39;d like to generate an SQL Script that contains the SQL to create all of the triggers that exist in our database.  The triggers were added directly via the SSMS query pane so, there is currently no source other than the trigger on the database itself.  

I have already tried the method where you right-click the database, select `Tasks-&gt;Generate Scripts` and used the &quot;Script Entire Database and All Objects&quot; option.  While this does create a SQL script for the tables and constraints, it does not generate SQL for the triggers.  

I also understand that I can right click on each trigger in the database and select the Generate SQL Script option but, there is currently 46 tables under audit (For Insert, Update, and Delete).  

Rather manually generate an insert, update, and delete trigger script for each of the 46 tables, is there an easier way to do this?  Or, should I start clicking, copying, and pasting?

Content Type	Original Author	Original Content on Stackoverflow
Question	user867198	View Question on Stackoverflow
Solution 1 - Sql	Joe G Joseph	View Answer on Stackoverflow
Solution 2 - Sql	John Woo	View Answer on Stackoverflow

SQL Server : GROUP BY clause to get comma-separated values

Sql Problem Overview

Sql Solutions

Solution 1 - Sql

Solution 2 - Sql

Can I use my existing git repo with openshift?

Rails: where does the infamous "current_user" come from?

Attributions