The gateway can handle deeply nested selects, but Microsoft SQL Server has an undocumented restriction on how deep selects can be nested. Testing of Microsoft SQL Server has revealed that only up to 48 nested selects work. If more than 48 selects are nested, SQL Server will generate an error saying that the query is nested too deeply.