StoredProcedures to count records
HI,
I've to write stored procedures for count the records based on some conditions.For example,I have table with name,address,number,new totally 4 fields.Here "new" field is filled by True or False.Now i've to write stored procedures to count the records which have "True" in "new" field and which have "False" in "new" field.Can anyone help me to do this?