StoredProcedures to count records

Question

HI I've to write stored procedures for count the records based on some conditions.For exampleI have table with nameaddressnumbernew 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?

Kiresh Gangariya · Answer

Hi SELECT Count ( Id ) AS TotalCount FROM TableName where new = 1 UNION SELECT Count ( Id ) AS TotalCount FROM TableName where new = 0

Kiresh Gangariya · Answer

Mark it as Help.

Kavi suja · Answer

Hi Thank you Hitesh.It helps me :)

Kavi suja · Answer

Hi Thank you SunnyKumar.It helps me :)

Sunny Sharma · Answer

Hi Kavitha use the pattern below: ------------------------------- CREATE PROCEDURE CountRecords AS BEGIN SELECT COUNT(name) FROM MyTable where new=0; END --------------------------- Hope it helps :)