There's no need for a dynamic query here, since you are limited in the number of address lines you can have.  I also replaced your PIVOT with a CROSSTAB, because it's...

There are 11 possible relationships between two intervals, requiring at least 22 rows to represent completely.  You have provided less than a quarter of the minimum to adequately test anything.

Yes, do an "UNPIVOT" first.  I'm using CROSS APPLY to do the "UNPIVOT".

SELECT...

Just filter out records with a NULL before doing your crosstab.  And do you really have strings that contain the word NULL rather than NULL values?

Please post sample data and expected results.  Follow the first link in my signature for details.

NOTE: Views cannot use dynamic SQL.

Drew

You asked this same exact question last month.

Drew

Check out this blog on Working with Precedence Constraints, specifically the section on Defining Workflow by Expressions.

Also, the conditions are mutually exclusive, so you only need...