troubleshooting Question

temp database needed in stored procedure?

Avatar of street216
street216 asked on
Microsoft SQL Server 2005
3 Comments1 Solution191 ViewsLast Modified:
experts,
i have a sproc that i need to create and i want to make sure i am doing it correctly. i need to match new documents (which have several attributes) with subscribers that have preferences set to which documents they want to receive notifications for. here the steps i've come up with:
- schedule using agent
- select new documents with attributes into temp table
- loop through documents to find matching subscribers for that day and insert those records into 'Subscription' table.
- delete temp table
- send email based on those records in 'Subscription' table.
I'd appreciate any advice on how to opimize this, the number of records could become large and I want to make sure I am ready if it does.

thanks.

Join the community to see this answer!
Join our exclusive community to see this answer & millions of others.
Unlock 1 Answer and 3 Comments.
Join the Community
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 3 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros