Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2000 Forums  SQL Server Development (2000)  Select and Count....combined?

Author  Topic  eddyo Starting Member 6 Posts Posted - 2001-04-12 : 23:42:56 I'm trying to use the following two queries on the table. Each takes about 4-5 seconds to run individually. Is there any way to combine them into one statement? Select count(*) as the_count from TABLE where part_ID='A1' Select top 50 * from TABLE where part_ID='A1'