Have you considered instead of binding them just running a:
sp_refreshview 
across all the views when a base table changes? (or across all views that could possibly be affected, if...

Not necessarily.  You can use CONTEXT_INFO() to pass a "flag" to the trigger to "tell" it not to update.  You might also look into replication.

Below is a sample...

All you have to set / pass in is the "@number_of_months", although you could pass in a different ending month if you wanted to.

DECLARE @number_of_months...

OPENQUERY accepts only a literal string query (review the syntax for OPENQUERY() to confirm this).

You have to use dynamic SQL if you want to build a dynamic OPENQUERY...

Yes, the trigger will fire again.

The easiest way around that is to use CONTEXT_INFO to set a "flag byte" to "tell" the trigger not to update on the...

This looks like it might just be some type of bug.  Do you have the latest svc pack for that SQL applied?

What you need/want is a CROSS JOIN.  That will match every ID with every year:

SELECT n.ID, y.year
FROM dbo.Name n
CROSS JOIN (
    SELECT...