locked
Send E-Mail , RRS feed

  • Question

  • Hi All ,

    Am working on a subscription .

    1. We have mysql Database that has 2 tables user and and time entries .

    2. I have written a query to find the names & their email addresses of the users who have not filled there time sheets .

    Requirement is :

    3. Send the email on individual basis to the users whose name is in the query .

    Kindly Suggest

    Priya

    Friday, November 22, 2013 12:18 PM

Answers

  • Hi Priya,

    It seems that your requirement had been solved on another thread by Visakh16 using the query.

    DECLARE @EMailList varchar(max)
    SET @EmailList=STUFF((SELECT ';' + Email 
    FROM Linkedservername.dbname.dbo.tablename
    ....any conditions here
    ),1,1,'')

    I post the answer so it will helpful for other forum members who have the similar issue.

    Regards,


    Charlie Liao
    TechNet Community Support


    • Edited by Charlie Liao Monday, November 25, 2013 2:37 PM
    • Marked as answer by Charlie Liao Saturday, November 30, 2013 1:01 PM
    Monday, November 25, 2013 2:36 PM

All replies

  • Hi Saeid ,

    Am looking forward to  both the solution from sql server reporting services as well as sql server agent email whichever is more suitable will opt for that .So in ssrs we can have subscriptions but don't have idea how to implement the logic from it .

    Thanks

    Priya

    Friday, November 22, 2013 1:48 PM
  • Hi Priya,

    It seems that your requirement had been solved on another thread by Visakh16 using the query.

    DECLARE @EMailList varchar(max)
    SET @EmailList=STUFF((SELECT ';' + Email 
    FROM Linkedservername.dbname.dbo.tablename
    ....any conditions here
    ),1,1,'')

    I post the answer so it will helpful for other forum members who have the similar issue.

    Regards,


    Charlie Liao
    TechNet Community Support


    • Edited by Charlie Liao Monday, November 25, 2013 2:37 PM
    • Marked as answer by Charlie Liao Saturday, November 30, 2013 1:01 PM
    Monday, November 25, 2013 2:36 PM