This is why I like exposing through controlled stored procedures for the most part and setting resource limits as opposed to "indefinite time or until i run out of temp space thrashing disks for more swap space" #[0]

Reply to this note

Please Login to reply.

Discussion

Why go so far as using a sproc? Couldn't you get the same from a view?

I guess every situation is going to present different needs. Stored procs afford some semblence of upfront constraints on what can be interrogated and a logic point for short circuiting.