Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

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

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Today @ 7:58 PM
Points: 75, Visits: 344
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


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Today @ 4:31 AM
Points: 1,400, Visits: 6,892
Duplicate post - please reply to:

http://www.sqlservercentral.com/Forums/Topic887195-392-1.aspx


BrainDonor
Linkedin
Post #887204
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse