Get All record from my database for the month by Percentage
I am building a report for my application using VS2010.  
My DB has two tables:Users and clinical_data.The Users table has a Column named:Gender,  
PatientRegistrationNo and the Clinical_data table contains Column:RegistrationNo.
For each Registered user that exit in the Users table and has Clinical_data store for  
him or her, I want my Query to show:  
Total Count of Male and Female, % of Male and Female for the Current Date:
This is my query but is not working for me:

    select COUNT(gender )  From Bio_Data
where  DateCreated = ADDDATE(GETDATE());


Get All record from my database for the month by Percentage
===

I am building a report for my application using VS2010.  
My DB has two tables:Users and clinical_data.The Users table has a Column named:Gender,  
PatientRegistrationNo and the Clinical_data table contains Column:RegistrationNo.
For each Registered user that exit in the Users table and has Clinical_data store for  
him or her, I want my Query to show:  
Total Count of Male and Female, % of Male and Female for the Current Date:
This is my query but is not working for me:

    select COUNT(gender )  From Bio_Data
where  DateCreated = ADDDATE(GETDATE());

