Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
learntsql
524 Posts |
 Posted - 2013-10-09 : 01:45:54
|
| Hi All,I am recently assigned to a new project and i see this application is so complex in terms of database.I mean to see some output finally it has to run so many nested procedures across many databases.when any issue comes we need to debug through all the levels of procedures across different databases.Internally each procedure does so many calculations and loaded into some tables.These tables are temparory tables.Can any one please guide me how to handle this kind of applications?I know my request is so open but not sure how to raise it.Please help me in this?TIA. |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2013-10-09 : 02:17:07
|
| no other way other than putting intermediate selects to check the contents of temporary tables and then make sure the contents are same as what you expect.------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/https://www.facebook.com/VmBlogs |
 |
|
|
James K
Master Smack Fu Yak Hacker
3873 Posts |
Posted - 2013-10-09 : 09:05:16
|
| One approach that I have found useful is to consider a few trivial/simplified cases. In the outermost query/stored procedure, add one or more where clauses to filter out most of the data, so that the rest of the query is working with just one or two rows of data. Then, trace through to see what it is doing to get an understanding of the program logic and states of the data. |
|
|
|
learntsql
524 Posts |
Posted - 2013-10-09 : 11:57:57
|
| Thank you all for your quick and usefull reply, though the query was so open. |
|
|
|
|
|
|
Help me in understanding the flow.