InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comWed, 19 Jun 2013 22:54:50 GMT20http://www.sqlservercentral.com/Forums/Topic1385047-392-1.aspxIf 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[code="sql"]SELECT @Var = MAX(ID) FROM #Temp[/code]Thu, 15 Nov 2012 03:41:44 GMTanthony.greenhttp://www.sqlservercentral.com/Forums/Topic1385047-392-1.aspxHi,I have i temp table as[code="sql"]CREATE TABLE #TEMP (ID INT)[/code]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.Thu, 15 Nov 2012 03:36:26 GMTShadab Shah