How To Put A Select Statement And Get Results In A Stored Procedure

Hello,

I have written a stored procedure where I prompt the user for the Year and the Month (see below)

How do I take the variable @TheMonth and find out how many days is in the month and then loop to display a total for
every day in the selected month.

Can someone please point me in the right direction.


CREATE PROCEDURE crm_contact_frequency_report

@TheYear         varchar(4),
@TheMonth      varchar(2)

AS

SELECT   

/* EMAILS (B) */
(SELECT COUNT(*) FROM dbo.CampaignResponse A
  INNER  JOIN Email B ON A.subject = B.subject
  WHERE (YEAR(B.CreatedOn) = @TheYear) AND (MONTH(B.CreatedOn) = @TheMonth)
  AND   (B.directioncode = 1)
) AS    Total_EmailOutgoing,

(SELECT COUNT(*) FROM dbo.CampaignResponse A
  INNER  JOIN Email B ON A.subject = B.subject
  WHERE (YEAR(B.CreatedOn) = @TheYear) AND (MONTH(B.CreatedOn) = @TheMonth)
  AND   (B.directioncode = 0)
) AS    Total_EmailImconing,

(SELECT COUNT(*) FROM dbo.CampaignResponse A
  INNER  JOIN Email B ON A.subject = B.subject
  WHERE (YEAR(B.CreatedOn) = @TheYear) AND (MONTH(B.CreatedOn) = @TheMonth)
  AND   (B.directioncode IS NULL)
) AS    Total_EmailNotListed,

(SELECT COUNT(*) FROM dbo.CampaignResponse A
  INNER  JOIN Email B ON A.subject = B.subject
  WHERE (YEAR(B.CreatedOn) = @TheYear) AND (MONTH(B.CreatedOn) = @TheMonth)
) AS    Total_All_Emails,


/* PHONE CALLS (C) */
(SELECT COUNT(*) FROM dbo.CampaignResponse A
  INNER  JOIN PhoneCall C ON A.subject = C.subject
  WHERE (YEAR(C.CreatedOn) = @TheYear) AND (MONTH(C.CreatedOn) = @TheMonth)
  AND   (C.directioncode = 1)
) AS    Total_CallOutgoing,

(SELECT COUNT(*) FROM dbo.CampaignResponse A
  INNER  JOIN PhoneCall C ON A.subject = C.subject
  WHERE (YEAR(C.CreatedOn) = @TheYear) AND (MONTH(C.CreatedOn) = @TheMonth)
  AND   (C.directioncode = 0)
) AS    Total_CallIncoming,

(SELECT COUNT(*) FROM dbo.CampaignResponse A
  INNER  JOIN PhoneCall C ON A.subject = C.subject
  WHERE (YEAR(C.CreatedOn) = @TheYear) AND (MONTH(C.CreatedOn) = @TheMonth)
  AND   (C.directioncode IS NULL)
) AS    Total_CallNotListed,

(SELECT COUNT(*) FROM dbo.CampaignResponse A
  INNER  JOIN PhoneCall C ON A.subject = C.subject
  WHERE (YEAR(C.CreatedOn) = @TheYear) AND (MONTH(C.CreatedOn) = @TheMonth)
) AS    Total_All_Calls,

/* FAXES (D) */
(SELECT COUNT(*) FROM dbo.CampaignResponse A
  INNER  JOIN Fax D ON A.subject = D.subject
  WHERE (YEAR(D.CreatedOn) = @TheYear) AND (MONTH(D.CreatedOn) = @TheMonth)
  AND   (D.directioncode = 1)
) AS    Total_FaxOutgoing,

(SELECT COUNT(*) FROM dbo.CampaignResponse A
  INNER  JOIN Fax D ON A.subject = D.subject
  WHERE (YEAR(D.CreatedOn) = @TheYear) AND (MONTH(D.CreatedOn) = @TheMonth)
  AND   (D.directioncode = 0)
) AS    Total_FaxIncoming,

(SELECT COUNT(*) FROM dbo.CampaignResponse A
  INNER  JOIN Fax D ON A.subject = D.subject
  WHERE (YEAR(D.CreatedOn) = @TheYear) AND (MONTH(D.CreatedOn) = @TheMonth)
  AND   (D.directioncode IS NULL)
) AS    Total_FaxNotListed,

(SELECT COUNT(*) FROM dbo.CampaignResponse A
  INNER  JOIN Fax D ON A.subject = D.subject
  WHERE (YEAR(D.CreatedOn) = @TheYear) AND (MONTH(D.CreatedOn) = @TheMonth)
) AS    Total_All_Faxes

FROM   CampaignResponse A
GO