Post reply

Generate reports

  • February 28, 2013 at 6:18 pm

    #290136

    I have a question related to SSRS. What i do is after all ETL process i am generating a report off of a table that has numerous columns. I have a column in the table that store integer values. My requirement is that the report should be sent out to all the recipients only if a row in that column is greater than 0 Else don't send out any email at all. I have been googling for a while and i can't seem to find a solution. Any advise/direction would be much appreciated.

    Thanks.

  • February 28, 2013 at 7:10 pm

    #1592221

    Google sp_send_dbmail.

    "I cant stress enough the importance of switching from a sequential files mindset to set-based thinking. After you make the switch, you can spend your time tuning and optimizing your queries instead of maintaining lengthy, poor-performing code."

    -- Itzik Ben-Gan 2001

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply