can stored procedure have multiple select statements code example

Example: stored procedure sql get multiple variable selects

Declare @Phone nvarchar(30); 
Declare @Fax nvarchar(30); 

select @Phone = phone , @Fax = fax from customer where customerID = 1;