SQL Stored Procedure set variables using SELECT

May 26, 2023 by Tarik

select @currentTerm = CurrentTerm, @termID = TermID, @endDate = EndDate
    from table1
    where IsCurrent = 1