# List of Procedures

| Name | Schema | Description | Modify Date | Create Date | Encrypted
--- | --- | --- | --- | --- | --- | ---
| aa | dbo |  | 12/23/2010 8:07:43 AM | 12/23/2010 8:07:43 AM |
| bb | dbo |  | 12/23/2010 8:23:37 AM | 12/23/2010 8:23:37 AM |
| sp_alterdiagram | dbo |  | 6/20/2011 3:16:00 PM | 6/20/2011 3:16:00 PM |
| sp_creatediagram | dbo |  | 6/20/2011 3:16:00 PM | 6/20/2011 3:16:00 PM |
| sp_dropdiagram | dbo |  | 6/20/2011 3:16:00 PM | 6/20/2011 3:16:00 PM |
| sp_helpdiagramdefinition | dbo |  | 6/20/2011 3:16:00 PM | 6/20/2011 3:16:00 PM |
| sp_helpdiagrams | dbo |  | 6/20/2011 3:16:00 PM | 6/20/2011 3:16:00 PM |
| sp_renamediagram | dbo |  | 6/20/2011 3:16:00 PM | 6/20/2011 3:16:00 PM |
| sp_t | dbo |  | 12/22/2010 11:07:45 PM | 12/22/2010 11:07:45 PM |
| sp_upgraddiagrams | dbo |  | 6/20/2011 3:15:59 PM | 6/20/2011 3:15:59 PM |
| usp_b | dbo |  | 1/21/2011 2:57:26 AM | 1/21/2011 2:57:26 AM |
| usp_delete_t99 | dbo |  | 12/18/2011 2:06:28 PM | 12/18/2011 2:06:28 PM |
| usp_testddl | dbo |  | 7/22/2011 7:34:46 PM | 7/22/2011 7:34:46 PM |
| uspCurrencyCursor | dbo | mobi uspCurencyCursor | 12/23/2010 8:11:33 AM | 12/23/2010 8:11:33 AM |
| uspGetBillOfMaterials | dbo | Stored procedure using a recursive query to return a multi-level bill of material for the specified ProductID. | 8/8/2010 5:23:46 PM | 8/8/2010 5:23:46 PM |
| uspGetEmployeeManagers | dbo | Stored procedure using a recursive query to return the direct and indirect managers of the specified employee. | 8/8/2010 5:23:46 PM | 8/8/2010 5:23:46 PM |
| uspGetManagerEmployees | dbo | Stored procedure using a recursive query to return the direct and indirect employees of the specified manager. | 8/8/2010 5:23:46 PM | 8/8/2010 5:23:46 PM |
| uspGetWhereUsedProductID | dbo | Stored procedure using a recursive query to return all components or assemblies that directly or indirectly use the specified ProductID. | 8/8/2010 5:23:46 PM | 8/8/2010 5:23:46 PM |
| uspLogError | dbo | Logs error information in the ErrorLog table about the error that caused execution to jump to the CATCH block of a TRY...CATCH construct. Should be executed from within the scope of a CATCH block otherwise it will return without inserting error information. | 8/8/2010 5:21:43 PM | 8/8/2010 5:21:43 PM |
| uspPrintError | dbo | Prints error information about the error that caused execution to jump to the CATCH block of a TRY...CATCH construct. Should be executed from within the scope of a CATCH block otherwise it will return without printing any error information. | 8/8/2010 5:21:43 PM | 8/8/2010 5:21:43 PM |
| uspSearchCandidateResumes | dbo |  | 8/8/2010 5:23:47 PM | 8/8/2010 5:23:47 PM |
| uspUpdateEmployeeHireInfo | HumanResources | Updates the Employee table and inserts a new row in the EmployeePayHistory table with the values specified in the input parameters. | 8/8/2010 5:23:46 PM | 8/8/2010 5:23:46 PM |
| uspUpdateEmployeeLogin | HumanResources | Updates the Employee table with the values specified in the input parameters for the given BusinessEntityID. | 8/8/2010 5:23:47 PM | 8/8/2010 5:23:47 PM |
| uspUpdateEmployeePersonalInfo | HumanResources | Updates the Employee table with the values specified in the input parameters for the given EmployeeID. | 8/8/2010 5:23:47 PM | 8/8/2010 5:23:47 PM |
| uspGetList | Production |  | 12/23/2010 6:58:48 AM | 12/23/2010 6:58:48 AM |