Procedure

use IlnurKurs

go
CREATE  PROCEDURE Get_date_of_first_buy_material(
@kod_mat int,
@date_of_first_buy date OUTPUT
)
AS
BEGIN

    set @date_of_first_buy = (SELECT MIN(date_of_post) from Uchet
    where (@kod_mat=kod_mat))
END