471,601 Members | 2,094 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,601 software developers and data experts.

New to stored procedure

Hello everyone,

I'm working a project using MS Project 2003 database. What I need to do is to get all entries for a specific user, from a specific project with specific citerias.

Its a web application, made with C#.

As it is right now, we're doing multiple queries with Data readers and DataTable, filtering those tables to fill new tables to achieve our goal. But the process takes about 13 sec to complete which is way too long.

So I decided to create a stored procedure and optimize the queries.

But I'm not a DBA, i'm a junior programmer and I don't know the subtleties of SQL Server.

Finally, here's my question.

It is possible or viable to, within a stored proc, parse a recordset and for each record to execute another query (maybe 2 or 3 times within the procedure), and fill a temporary recordset (from multiple select) which will be ultimely the one returned?

If you need more information, let me know! But I'm mainly looking for a general answer so I can apply it to more problems.

Thanks alot!
Aug 9 '06 #1
0 1146

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

4 posts views Thread by Rhino | last post: by
8 posts views Thread by Thomasb | last post: by
2 posts views Thread by Dino L. | last post: by
3 posts views Thread by kd | last post: by
2 posts views Thread by jed | last post: by
reply views Thread by leo001 | last post: by
reply views Thread by MichaelMortimer | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.