CREATEPROCEDURE Question_State_Num_Get AS declare@Statenvarchar (100) declare@State1nvarchar (100) declare@State2nvarchar (100) set@State='0' set@State1='1' set@State2='2' set@State=(selectcount(ID) from Question where State=@State) set@State1=(selectcount(ID) from Question where State=@State1) set@State2=(selectcount(ID) from Question where State=@State2) select@Stateas State,@State1as State1,@State2as State2 GO