To execute the code against a different database then you just need to put the database name infront of the sp_ExecuteSQL stored proc. So:

EXEC DatabaseName.dbo.sp_ExecuteSQL

I think if you just set...

I'm not quite sure why but the problem is the parameters you are trying to pass in.

If you look at the value @ViewStr takes when it is passed into sp_ExecuteSQL...

Paul, that is essentially what we have at the moment, the balance table joins to a few type 2 and type 1 dimensions and forms the heart of our data...

Thanks all, very useful replies.

I hadn't thought about taking the fields into a dimension table, but I don't think they would be appropriate. The changing values are things like current...