How do you count number of records in Sql?

Expand Post »

Hi:

I'm writing a VBA macro in xls to chart various records that I'm querying from MS SQL. One of the values that are most important for me to chart is the total number of records. The way I have the xls code, I can pull the data into xls and then count rows. However, sometimes the number of rows queried exceeds the 65K max rows in xls...and the program fails.

Could anyone suggest how I could just extract the number of records directly from sql, using a code that I can embed in my xls code?

Thanks in advance for your help!
-m

Similar Threads

Question with xls querries from sql in Visual Basic 4 / 5 / 6
Count number of one's in 32 bits in C
performance troubles.. in MS SQL
Count number of checkboxes being checked in asp.net in ASP
Displaying a certain number of records in MS SQL

mason12345

Reputation Points: 10

Solved Threads: 0

Newbie Poster

Offline

6 posts
since Feb 2007

Permalink

Feb 17th, 2007

Re: How do you count number of records in Sql?

Normaly I would use COUNT (), but i'm not sure about embeding SQL code in XLS!?

cheers

FreelanceHW

Reputation Points: 10

Solved Threads: 0

Newbie Poster

Offline

1 posts
since Feb 2007

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.

Previous Thread in MS SQL Forum Timeline: How to Backup database - SQL Server 2000

Next Thread in MS SQL Forum Timeline: SQL Report Help

DaniWeb Message

Cancel Changes

User Name
Password