Count the rows SQL Server 2005

• WangcChiKaBastar

  SSCrazy

  Points: 2297

  More actions

  March 22, 2010 at 1:32 am

  #139431

  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

• BrainDonor

  SSCoach

  Points: 19254

  More actions

  March 22, 2010 at 2:11 am

  #1137441

  Duplicate post - please reply to:

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

  Steve Hall
  Linkedin
  Blog Site