I have tried to use parameterized views, but the SQL statement which gets generated is too long, so I have been trying to approach it from a different angle (hence the CREATE SQL VIEW ...). Parameterized views do exactly what I want, except for this one problem.

Thanks.