I have a complex sql query that I'd like to create a view for. I went to views, create view and copied the query into it. But it won't let me pass the @variable that I need there. How do I do this? Basically, whenever I use the view, I would have that parameter being passed in.