Impossible Function

Hi! all

I need to store the output of two select statement in a Temporal Table inside a storeProcedure. and used them later in a Select statement in the same Procedure

CREATE PROCEDURE [update_Alarm_1]

declare @datetime1 ?????

declare @datetime2 ?????

[SELECT Coming
FROM Student_Log
where datepart(hour, AL_Coming) = 9
and
AL_State = 0 ] = @datetime1



[SELECT Coming
FROM Student_Log
where datepart(hour, AL_Coming) = 9
and
AL_State = 1 ] = @datetime2



[SELECT date_part( 'minute', datetime1 - datetime2 )] = @result



AS UPDATE [Time_Result]

SET [Comment] = @Comment_2

WHERE
( [result] = @result)

Thanks in Advance