stevewes (9/23/2013)
Hi, how do I do this ?my select statement goes something like this
Select count(*) AS EMAILQFULL,column name from tablename
group by column name
this returns the number of rows in the table, but I only want it to notify me if there are more than 90 rows this is the part I am stuck on.:(
90 rows for each group or 90 rows in the entire table?
I am guessing you have multiple groups here? Just add a HAVING clause.
Does this help?
Select count(*) AS EMAILQFULL, [column name ]
from tablename
group by [column name]
HAVING COUNT(*) >= 90
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/