Traversing through Temp Table

• Shadab Shah

  SSCarpal Tunnel

  Points: 4759

  More actions

  November 15, 2012 at 3:36 am

  #264846

  Hi,

  I have i temp table as

  CREATE TABLE #TEMP (ID INT)

  In this temp table i would be having 2 or more than 2 records. They would be necessarily 0 or 1 value.

  Suppose if any one of the present value in temp table is 1 then i have to set a variable(Say the variable is @var) to 1. If all the records in the temp table are 0 then i have to set a variable(@var) value as 0.

• Ant-Green

  SSC Guru

  Points: 113509

  More actions

  November 15, 2012 at 3:41 am

  #1559266

  If they can only ever be 0 or 1 then max will do the job, as if anything is set to 1 it will return 1 or if everything is 0 it will return 0

  SELECT @Var = MAX(ID) FROM #Temp