Garadin (7/1/2011)
I'm just glad I decided to test it before I answered... or I'd have been wrong. :hehe:
Ha! Don't feel like the Lone Stranger on that one - I have to do that too all too often myself.
Anyway, the error is "Invalid column name 'PGID'." on the called procedure
So if I open the called (or child?) procedure (from the server to be sure it's the compiled program) and run it, no errors. If I call it manually from an exec, it chokes. So it may just be a parameter value snafu.
Parameters are fantastic! And yet, they're such a pain sometimes. :w00t:
The greatest enemy of knowledge is not ignorance, it is the illusion of knowledge. - Stephen Hawking