stored procedure returing more than 2 values

Very simple!

End your stored procedure with :

SELECT @Name as name, @address as address

You could use output variables

CREATE PROCEDURE  GetDetails

	(
		@Input1			SMALLINT,
		@Input2			SMALLINT,
		@Output1		INT OUTPUT
		@Output2		VARCHAR(50) OUTPUT
	)

AS

SET NOCOUNT ON

SELECT
	@Output1 = Field1, 
	@Output2 = Field2
FROM
	MyTable
WHERE
	SomeField = @Input1
AND
	SomeOtherField = @Input2 

Then just grab the values from whatever code is consuming the procedure

http://dotnetgems.blogspot.com/2007/10/using-output-parameters-in-stored.html[^]

Or you could just return a ResultSet and read the values, both are valid.

I didn't see if you mentioned the amount of returning data rows. If you're returning several rows from the procedure, you could simply write:

create procedure SomeProcedure 
   @email varchar(max),
   @fromdate datetime,
   @todate datetime as
begin
   select name,address 
   from Attendance_Master 
   where OffEmail=@Email 
   and LoginTime between @fromdate and @todate
end

One question though: If you're fetching few values from a table based on conditions on few fields, why do you want to do this using a procedure? You didn't mention the technology you're going to use to call this procedure, but if you're using for example C#, wouldn't it be simpler to execute the query as-is from the client?