CREATE PROC dbo.InMonth @Date datetime AS

SET NOCOUNT ON

SELECT Member_ID, Effective_Dt, Termination_Dt

FROM Members

WHERE

DatePart(m, Effective_Dt) = DatePart(m, @Date) and

DatePart(yyyy, Effective_Dt) = Datepart(yyyy, @Date) and

DatePart(m, Termination_Dt) = DatePart(m, @Date) and

DatePart(yyyy,...