Priming Select Count(*) into a variable

• Express12

  SSCoach

  Points: 18514

  More actions

  March 2, 2006 at 9:53 am

  #112972

  The following SQL returns the value 1 all the time:

  DECLARE @y INT

  SELECT

  @y = (SELECT COUNT(*)  FROM Customers)

  How can I get the select count(*) to return the actual number of Customers into @y ??

  BT

• PW-201837

  SSC-Insane

  Points: 20805

  More actions

  March 2, 2006 at 9:55 am

  #624376

  DECLARE @y INT

  SELECT @y = COUNT(*)  FROM Customers