Note: Views get saved in the database, and can be available to other queries and stored procedures. However, if this view is only used at this one place, it can be easily eliminated using other ...

I need to select some data (surprise) from several tables in a linked database which is running SQL Server 2000.<BR><BR>Now the resulting data set will be about 10,000 records taken from ~ 8 ...

lukaseder changed the title Work around SQL Server's buggy UNION with ORDER BY .. OFFSET .. FETCH implementation in derived tables - Merge [#16938] Work around SQL Server's peculiar UNION with ORDER ...