Rich
6046f905b1
Modified getAnnotationAuditsChronologyByItemID to include datetime parameter
...
Modified vefn_GetMyChronology to include datetime parameter
Modified getContentAuditsChronologyByItemID to include datetime parameter
Modified getContentAuditsSummaryByItemID to include datetime parameter
Modified vefn_ChronologyReport to include datetime parameter
2013-04-08 14:37:21 +00:00
Rich
635b88de4d
Exit on SQL script failure
...
Added error handling to RunScript method
Exit on SQL script failure
Changed vefn_ChronologyReport
Changed how check for prior existence of rofst
2013-02-08 23:47:21 +00:00
Rich
676ec9fb30
Revised vefn_getChronology to speed up performance
2013-01-09 20:32:21 +00:00
Rich
77338c048d
Added vefn_GetMyChronology user function
...
Fixed getContentAuditsChronologyByItemID stored procedure
Fixed getContentAuditsSummaryByItemID stored procedure
Fixed getAnnotationAuditsChronologyByItemID stored procedure
2012-11-13 16:08:14 +00:00
Rich
173dd85ccf
Added "OPTION (MAXRECURSION 10000) to all recursive queries. Remove Change Manager stored procedure "getItemAuditsByItemID"
2012-11-05 21:55:27 +00:00
29f2d79fed
include copyright notice for each stored procedure, function, and trigger
...
added VEREV3PI “WOG - Emergency Response Guidelines Rev. 2 for NSP”
2012-10-25 18:47:22 +00:00
Rich
11ba8ffa78
fixed stored procedure for consistency check to speed up processing
...
added history.recid to config
2012-02-09 16:11:02 +00:00
Rich
e4d85f568d
Check to see if the table exists before it is modified
2012-01-24 21:23:42 +00:00
Rich
f9fa4fa3c1
Script changed to be able to run repeatedly
...
Add DROUsages to Concistency Check
2012-01-24 20:35:13 +00:00
Rich
83f9e1cc75
SQL script to convert data to Approval format
...
Added Status before and after running script
Added query conditions to limit the databases listed
2012-01-23 18:21:06 +00:00
