ALTER PROCEDURE GetActiveEventsByLocation
	@LocationId int
AS
	select EventId from sbEvent where @LocationId = LocationId and (Eternal = 1 or (StartTime < CURRENT_TIMESTAMP and EndTime > CURRENT_TIMESTAMP))
RETURN 

GO




 CREATE PROCEDURE GetAllActiveEvents
	
AS
	select EventId from sbEvent where (Eternal = 1 or (StartTime < CURRENT_TIMESTAMP and EndTime > CURRENT_TIMESTAMP))
RETURN 

GO

	select EventId from sbEvent where @LocationId = LocationId and (Eternal = 1 or (StartTime < CURRENT_TIMESTAMP and EndTime > CURRENT_TIMESTAMP))
