This post outlines how to use the OPENQUERY SQL syntax to skirt the SQL Server limit of 260 tables in a view when writing a Dynamics GP SmartList.
See the original article here: Creating Global Dynamics GP SmartLists with OPENQUERY