http://www.sqlservercentral.com/Articles tagged Programming, Stored Procedures, Advanced Querying posted on SQLServerCentral.comen-us360sjones@sqlservercentral.com (Steve Jones)Robert is our expert on dynamic sql. This week he offers some good hints for planning the contruction of a proc that will use dynamic sql. He also adds some suggestions on how to format the code so that when you return to it later, you can figure out what you were doing! http://www.sqlservercentral.com/articles/Miscellaneous/howtobuilddynamicstoredprocedures/968/2005/12/16http://www.sqlservercentral.com/articles/Miscellaneous/howtobuilddynamicstoredprocedures/968/Robert is our expert on dynamic sql. This week he offers some good hints for planning the contruction of a proc that will use dynamic sql. He also adds some suggestions on how to format the code so that when you return to it later, you can figure out what you were doing! http://www.sqlservercentral.com/articles/Miscellaneous/howtobuilddynamicstoredprocedures/968/2005/12/16http://www.sqlservercentral.com/articles/Miscellaneous/howtobuilddynamicstoredprocedures/968/Are you using default values for your parameters? Using named parameters when you call the proc or passing the values by ordinal? Should you be? Andy thinks 6 out of 10 of our readers will agree with his point of view, we'll be a little more conservative and guess that 5 of out 10 will be closer. http://www.sqlservercentral.com/articles/Miscellaneous/defaultvaluesandnamedparametersforstoredprocs/882/2003/01/08http://www.sqlservercentral.com/articles/Miscellaneous/defaultvaluesandnamedparametersforstoredprocs/882/