> But I have to agree with Chris - Why would you want the count on every row? > If nothing else, this wastes network bandwidth. You can either return the > count as the return value from the stored procedure, or simply have two > separate queries - one for the count and one for the data.
Or even as David mentioned - throw your data into an array and you'll be able to access the count right from UBOUND(arrName, 2) Chris Tifer http://www.emailajoke.com --- You are currently subscribed to activeserverpages as: [email protected] To unsubscribe send a blank email to [EMAIL PROTECTED]
