Create a stored procedure in your database, something like this:
CREATE PROCEDURE dbo.SomeStoredProcNameHere @startDate DATE, @endDate DATE
AS
SET NOCOUNT, XACT_ABORT ON;
SELECT
COUNT(*) AS RecordsCreated,
SUM(CASE WHEN Field1 = 1 THEN 1 ELSE 0 END) AS CountOfField1,
SUM(CASE WHEN Field2 = 1 THEN 1 ELSE 0 END) AS CountOfField2
FROM
YourTable
WHERE
YourDateColumn >= @startDate
AND YourDateColumn < DATEADD(DAY,1,@endDate);
GO