How Would You Go About Creating Recurring Appointments? ASP/SQL Server

I initially tried building a coded system where numbers 1 through 10
referenced a certain type of recurring appointment, and would then call a
specific function for each, but as more appointments were added things began
to slow down quite a bit.

I've taken a different approach since, and decided
to create a single record for each recurring appointment, but this has
problems as well due to the fact that I have to search each time slot going
all the way out to the specified end date/time.

What is the most efficient way to create recurring appointments using ASP
and SQL Server?