THANK YOU,
In my case it better that I use a SP with ##Temp_Table.
>Define the SQL view without any conditions. Then issue select statements against it with your where clause.
>
>Or create your view and then a stored procedure that issues the select against the view. You can pass your parameters into the stored procedure and it processes the view accordingly.
>
>>I have this complex SQL Select and I like to use it as view but I need to pass parameters in the condition.
>>
>>How can I pass parameters to a view?