Stored Procedure Examples

[davidsims]

There are a ton of things that can only be done with Stored Procedures in Vision. It would be helpful if Deltek put out a guide on how to set up a stored procedure. Whenever I contact support, they want to charge me extra for stored procedures and custom workflows, but in my opinion, this information is vital to using the software.

[Gerald Cox]

This would be very helpful. I'll be sure to mention it next time I talk to support.

[courtenaybernier]

What type of stored procs are you looking for? We may have a few examples to provide.

[davidsims]

At the moment, I think I have figured out everything I need to do, but when I first started, I didn't have a clue.

We have 11 SPs set up now. Most of them fill in grids with change information from the info centers. (Fee Change Grid) One of them updates billing rates when the employee's salary is changed.

[matthew.rummler]

Hi David

At one point Deltek supplied me with a stored procedure to move data between Infocenters... While, under just the right circumstances the stored procedure would have been valuable I wasn't really able to use any of it.
What I think might be hand is a general framework example (which I was already beyond by the time they provided their example).
However if it will be helpful I will be happy to post the example they provided...