What I want to do is load the next parameter after 18488, next being 18489.
I have created a stored proc that takes the current parameter and finds the next parameter ie:
CREATE proc CustomPropertyiGetNextKey
@ThisPropertyKey int output
@ThisPropertyKey = min(PropertyKey)
propertyi..tblProperties with (nolock)
propertykey > @PreviousPropertyKey
and deleted = 0
I want to exec this proc each time my page refreshes, taking the previous parameter and finding the next
var URL = "property.jsp?Propkey=@PropertyKey"
var speed = 5000
location = URL