> I've done the same, but it's nowhere near as easy as having the > sql in <insert language of choice> files and directly checking > them out of source control.
I'll easily admit to being a Stored Procedure junkie - however as with anything else you have to remember, "there's a time and a place for everything." A simple select statement doesn't really need a SP but in the world of complex reporting when is a simple select statement ever enough? One of the biggest factors I use to decide to SP or not is code re-use. I'm working on an app right now where the same complex procedure is used on 4 pages and 3 reports... so moving things to a SP makes sense there. Hatton ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-community/message.cfm/messageid:314953 Subscription: http://www.houseoffusion.com/groups/cf-community/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-community/unsubscribe.cfm
