>I'm clueless on how to approach this thing.
Why can't you make something like
[EDITED]
SELECT count(*) FROM your_table WHERE Month(date) = Month(getdate())
AND YEAR(date) = YEAR(GetDate())
before you try to insert into the table?
You do insert only if your result is < 2.