Mark Breen
mark.breen at gmail.com
Tue Nov 9 12:37:56 CST 2004
Hello Arthur, Ahhh, it seems like it was a crazy feature to exclude, I have wondered why they did not allow us to do it. Thanks for that, I have the beta installed on a machine so I will have to have a more detailed play with it. Have you used SQL2005 much? What do you think of it? Thanks Mark On Tue, 09 Nov 2004 11:49:43 -0500, Arthur Fuller <artful at rogers.com> wrote: > Mark Breen wrote: > > >Hello Eric, > > > >I am interested in this topic also. > > > >I recently had to create a SQL statement that selected the top n > >number of records. It was a reasonably complex sql statement > >filtering on a table with 12 million records. > > > >In SQL you can say Select top 10 .... but you cannot say Select top > >@MyValue .... > > > > > > > > > One little footnore. In SQL 2005 you can say SELECT TOP @n. > _______________________________________________ > > > dba-SQLServer mailing list > dba-SQLServer at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/dba-sqlserver > http://www.databaseadvisors.com > >