jaytech

Comments

  • Ok, so the SQL was even easier than I thought... a simple sub-query on count and problem is solved! Thanks for the solution Petr Vilem SELECT (SELECT COUNT(*) AS Expr FROM table), someColumn
    in Alerting on SQL Server Insert Comment by jaytech October 2012
  • Very nice, that is pretty much what I am looking for. I will have to brush up on my SQL though since I am looking to include some of the row contents in the alert. I can't get the query to return the count and a merged field for the returned message at the same time. Thank you though, at least I can get an alert out there…
    in Alerting on SQL Server Insert Comment by jaytech October 2012
Avatar