Hello all,

I am just reading this article and I came across this:

Filter: Remove any functions in the WHERE clause, don't include views in your Transact-SQL code, may need additional indexes.

If I do not use views, what are the alternatives? I mean, in my situation, I want to select some data from a table and then use a few other select queries to work on the subset of data from the first select query?

How can I do this efficiently?

Thanks all