I am running this query
select distinct DATEname(YYYY,Created_Date) + ' ' +datename(mm,Created_Date) + ' ' + DATEname(dd,Created_Date)' Days Logged In'
from Session_Logons where User_ID = 13
which returns a row for each day a login to an application was recorded (there may have been multiple login on a given day, but I only want to record the fact that a login occurred on a given day. Therefore the rows returned are as follows
2010 November 9
2010 November 6
2010 October 31
How can I modify this to give me just a count of the total number of rows, i.e. how many days in total a login was made