Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

Count the rows SQL Server 2005 Expand / Collapse
Posted Monday, March 22, 2010 1:32 AM


Group: General Forum Members
Last Login: Tuesday, January 5, 2016 1:14 PM
Points: 105, Visits: 485
I have to write a sp that would give two data sets one with the coumns (metadata) like firstname, lastname, address, phonenumber

and then second result set would return just the count of the rows
count(*) of the above select

please advise
Post #887194
Posted Monday, March 22, 2010 2:11 AM



Group: General Forum Members
Last Login: 2 days ago @ 6:15 AM
Points: 1,802, Visits: 10,293
Duplicate post - please reply to:

Steve Hall
Blog Site
Post #887204
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse