Re: Stored Procedures - Am I going insane?

[Paul Hastings]

> worse negative performance impact [but] Cursors are going to be the answer
> anytime a solution must be done on a row-by-row basis."

you can often use a series of set operations against temp tables instead
of server side cursors or just plain sql if you're joe celko (or maybe tom 
potts who writes some of the most imaginative sql code).


~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists