Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Stored Proc that returns row count from another Stored Proc
Message
From
07/04/2009 09:15:17
Mike Cole
Yellow Lab Technologies
Stanley, Iowa, United States
 
 
To
All
General information
Forum:
Microsoft SQL Server
Category:
Stored procedures, Triggers, UDFs
Title:
Stored Proc that returns row count from another Stored Proc
Environment versions
SQL Server:
SQL Server 2005
Miscellaneous
Thread ID:
01393595
Message ID:
01393595
Views:
114
Is this possible? I am working on setting up paging on a form and I don't want to duplicate the joins and filters in a second query that just returns the count. I've seen an example of creating a temp table and inserting the results of a stored procedure into that table but I wanted to see if there was an easier way.
Very fitting: http://xkcd.com/386/
Next
Reply
Map
View

Click here to load this message in the networking platform