if exists (select * from sysobjects where
		name = 'sp_listcustomer' and type = 'P')
begin
	drop procedure sp_listcustomer
end
go

create procedure sp_listcustomer
@lastname varchar(100) = NULL,
@numrows int output
as
	select @numrows = count(*) from CUSTOMER where C_LAST_NAME = @lastname
	select C_LAST_NAME, C_FIRST_NAME, C_BIRTHDAY from CUSTOMER
		where C_LAST_NAME = @lastname
	return 23
go
