selecting count(*) from a table into an int variable

• winston Smith

  SSCoach

  Points: 19489

  More actions

  April 7, 2006 at 5:33 am

  #168445

  ive been trying this a number of ways;

  Declare

  @numRows int

  select

  @numrows = select count(*) from customer

  ======================================

  Declare @numRows int

  set @numrows = select count(*) from customer

  ======================================

   

  Declare @numRows int

  select @numrows = select rowcount from customer

  ======================================

   

  none will work. how can this be accomplished??

   

• Kenneth Wilhelmsson

  SSC-Dedicated

  Points: 30043

  More actions

  April 7, 2006 at 5:38 am

  #631457

  Almost there, you just need a pair of parenthesis

  Declare @numRows int

  select @numrows = (select count(*) from customer)

  /Kenneth

• winston Smith

  SSCoach

  Points: 19489

  More actions

  April 7, 2006 at 5:40 am

  #631458

  so near yet so far. thank you.

• Andreas AJV

  SSC Eights!

  Points: 800

  More actions

  April 7, 2006 at 6:21 am

  #631468

  Also....

  Declare @numRows int

  select @numrows =count(*) from customer

  

  ------------
  When you 've got a hammer, everything starts to look like a nail...