SUBQUERY IN SQL2000

• skidoo1200

  Newbie

  Points: 1

  More actions

  September 3, 2003 at 7:40 am

  #176329

  Using an isql statement with sql 6.5, I was able to perform this statement:

  insert into <database..table> values (<val1>, <val2>, -(select count(*) from <database..table))

  Sql2000 is now telling me that I cannot use a subquery this way and it must be a scalar expression.

  Is there anyway to perform the statement that worked in 6.5, in 2000?

• guarddata

  SSCertifiable

  Points: 6583

  More actions

  September 3, 2003 at 8:20 am

  #472366

  You might try

  INSERT INTO <table>

  SELECT val1, val2, COUNT(*) FROM <table>

  Guarddata-