----------------------------------------------------------- New Message on BDOTNET
----------------------------------------------------------- From: SriSamp Message 5 in Discussion There are multiple ways you can do this. (1) SELECT myCount = (SELECT COUNT(*) FROM yourTable), field1, field2 FROM yourTable In the above example, we execute the COUNT operation as an inner query and then select the other two fields. This query works fine for a table with a small number of rows. It can be extremely in-efficient when it comes to large tables. (2) DECLARE @myCount INT BEGIN SET @myCount = (SELECT COUNT(*) FROM yourTable) SELECT @myCount, field1, field2 FROM yourTable END This is a much faster version since the count is calculated only once. After that we just use that variable in the returned query. You can either embed this T-SQL inside a stored procedure or execute this as a complete string. HTH, Srinivas Sampath MVP - SQL Server http://www32.brinkster.com/srisamp ----------------------------------------------------------- To stop getting this e-mail, or change how often it arrives, go to your E-mail Settings. http://groups.msn.com/BDotNet/_emailsettings.msnw Need help? If you've forgotten your password, please go to Passport Member Services. http://groups.msn.com/_passportredir.msnw?ppmprop=help For other questions or feedback, go to our Contact Us page. http://groups.msn.com/contact If you do not want to receive future e-mail from this MSN group, or if you received this message by mistake, please click the "Remove" link below. On the pre-addressed e-mail message that opens, simply click "Send". Your e-mail address will be deleted from this group's mailing list. mailto:[EMAIL PROTECTED]
