Script entire db to find relevant Stored procedures
-
I have scripted my entire database to find the relevant stored procedures(related to case #4071749 - https://www.sqlservercentral.com/forums/topic/m:issing-datafinding-the-root-problem#post-4071649)
My function return zero values for specific columns, see screenshots:
Table "auditLevyBreakdown" returns zero data. I would like to find the relevant stored procedure to find the root cause. Please advise?
-
Please see my reply on the thread that spawned this need at
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally) -
This was removed by the editor as SPAM
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply