I am writing a stored procedure for executing search
and returning results. The Sproc is a bit complicated and has
gotten away from me, now I can't understand why I am getting
bad results.
Its long and detailed so, before I dump code and get yelled at,
I am wondering if it is OK to post a large SPROC here for general
debugging help?
Thanks.
Absolutely that's ok.
It would also be helpful if you posted any ddl, sample data, and desired results as well.
|||Yes, but ...
(And thanks for asking in advance!)
Before you do that, let me offer the following suggestions.
Often, it is best to 'build' a complicated procedure the way you build a structure, 'brick by brick'. Start out with a small part, get that working. Then add another small part, get that working.
When you are baffled, put in PRINT statements, printing the parameter and variable values, and even location in the code (for IF/WHILE switches) for verification.
And when you are ready to drop the whole thing here, please post the DDL for all associated tables, fabricate some sample data for those tables (in the form of INSERT statements), and a clear explanation of and example of desired output. See this link for help in putting it all together. The less 'set up' work we have to do, the more likely you are going to have folks tackle your problem and help you.
By going to that effort to prepare your 'presentation', the volunteers here can more easily get involved with your problem. If if is necessary to take the time to create a simulated environment just to try to help you, you will radically reduce the number of folks willing to make the time investment.
All that said, it is a great group of folks here, willing to help those willing to be helped.
|||Concur 100% with Dale. Much better to give too much information. What will get you "yelled" at is asking a quesiton like:
My stored proc won't work. Why?
And yes, that is far too true of an example 
No comments:
Post a Comment