A view can only contain a single select statement, no other statements are allowed.
Try an in-line table-valued function with those two variables as parameters to the function.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability