I write one SP that meets your requirement it takes userid as input parameter. In the SP it picks latest enddate of that user and compare with current date. According to the condition it update status also.
create procedure spCheckStatus @userid int
as
begin
declare @EndDate date
declare @CurrentDate date
select @EndDate=max(enddate) from table1 where userid=@userid
select @CurrentDate=getdate()
if @CurrentDate >= @EndDate
begin
update table2 set status='suspend' where userid=@userid
end
if @CurrentDate < @EndDate
begin
update table2 set status='active' where userid=@userid
end
end
try it....Hope its work for you.