Query: SELECT * FROM (SELECT row_number() OVER () as resultNum, [Collection].[IdCollection] AS [Collection__0], [Collection].[UserCreation] AS [Collection__1], CONVERT(VARCHAR(20), [Collection].[DateCreation], 20) AS [Collection__2], [Collection].[UserMaj] AS [Collection__3], CONVERT(VARCHAR(20), [Collection].[DateMaj], 20) AS [Collection__4], [Collection].[IdEditeur] AS [Collection__5], [Collection].[NumOrdre] AS [Collection__6], [Collection].[Libelle] AS [Collection__7], [Collection].[LibelleU] AS [Collection__8], [Collection].[ISSN] AS [Collection__9], [Collection].[MentionResp] AS [Collection__10], [Collection].[Notes] AS [Collection__11], [Collection].[IdLotEchange] AS [Collection__12], [Collection].[LibelleParallel] AS [Collection__13], [Editeur].[IdEditeur] AS [Editeur__14], [Editeur].[UserCreation] AS [Editeur__15], CONVERT(VARCHAR(20), [Editeur].[DateCreation], 20) AS [Editeur__16], [Editeur].[UserMaj] AS [Editeur__17], CONVERT(VARCHAR(20), [Editeur].[DateMaj], 20) AS [Editeur__18], [Editeur].[Nom] AS [Editeur__19], [Editeur].[Adresse1] AS [Editeur__20], [Editeur].[Adresse2] AS [Editeur__21], [Editeur].[CodePostal] AS [Editeur__22], [Editeur].[Ville] AS [Editeur__23], [Editeur].[Pays] AS [Editeur__24], [Editeur].[Tel] AS [Editeur__25], [Editeur].[Fax] AS [Editeur__26], [Editeur].[Telex] AS [Editeur__27], [Editeur].[Email] AS [Editeur__28], [Editeur].[Notes] AS [Editeur__29], [Editeur].[IdLotEchange] AS [Editeur__30] FROM [collection] AS [Collection] LEFT JOIN [EDITEUR] AS [Editeur] ON ([Collection].[IdEditeur] = [Editeur].[IdEditeur])  WHERE 1 = 1 ) as numberResults WHERE resultNum BETWEEN 1981 and 2010  

Query: SELECT * FROM (SELECT row_number() OVER () as resultNum, [Collection].[IdCollection] AS [Collection__0], [Collection].[UserCreation] AS [Collection__1], CONVERT(VARCHAR(20), [Collection].[DateCreation], 20) AS [Collection__2], [Collection].[UserMaj] AS [Collection__3], CONVERT(VARCHAR(20), [Collection].[DateMaj], 20) AS [Collection__4], [Collection].[IdEditeur] AS [Collection__5], [Collection].[NumOrdre] AS [Collection__6], [Collection].[Libelle] AS [Collection__7], [Collection].[LibelleU] AS [Collection__8], [Collection].[ISSN] AS [Collection__9], [Collection].[MentionResp] AS [Collection__10], [Collection].[Notes] AS [Collection__11], [Collection].[IdLotEchange] AS [Collection__12], [Collection].[LibelleParallel] AS [Collection__13], [Editeur].[IdEditeur] AS [Editeur__14], [Editeur].[UserCreation] AS [Editeur__15], CONVERT(VARCHAR(20), [Editeur].[DateCreation], 20) AS [Editeur__16], [Editeur].[UserMaj] AS [Editeur__17], CONVERT(VARCHAR(20), [Editeur].[DateMaj], 20) AS [Editeur__18], [Editeur].[Nom] AS [Editeur__19], [Editeur].[Adresse1] AS [Editeur__20], [Editeur].[Adresse2] AS [Editeur__21], [Editeur].[CodePostal] AS [Editeur__22], [Editeur].[Ville] AS [Editeur__23], [Editeur].[Pays] AS [Editeur__24], [Editeur].[Tel] AS [Editeur__25], [Editeur].[Fax] AS [Editeur__26], [Editeur].[Telex] AS [Editeur__27], [Editeur].[Email] AS [Editeur__28], [Editeur].[Notes] AS [Editeur__29], [Editeur].[IdLotEchange] AS [Editeur__30] FROM [collection] AS [Collection] LEFT JOIN [EDITEUR] AS [Editeur] ON ([Collection].[IdEditeur] = [Editeur].[IdEditeur])  WHERE 1 = 1 ) as numberResults WHERE resultNum BETWEEN 1981 and 2010