The solution is to use SQL views, materialized views, or create a new table that contains only the filtered data the user needs.

A reader recently pointed out to me that I could drastically simplify that retrieval code by leveraging SQL views. A SQL view pulls together multiple tables (and selected columns from those tables) ...

Why are there INFOMATION_SCHEMA and catalog views in SQL Server that do very similar things? For example, to retrieve a list of tables in a database, I can do it via sys.tables or INFORMATION ...

When executed, a PROC SQL view's output can be a subset or superset of one or more underlying files. Beginning in Version 7, you can reference a simple PROC SQL view to update its underlying data. SAS ...

A Version 6 PROC SQL Pass-Through view does not need to be updated to be used in Version 7 or Version 8. The conversion of PROC SQL Pass-Through views is automatic and does not require you to use the ...