Ken
JR> I'd be quite happy for somebody to come up with a reason to use SPs exclusively, as I've already said, but nobody has.<<
KM>>
OK - and PMFJI - how about this
1 - I can do anything with an SPT cursor that you can do with an RV.
2 - I can do things with an SPT cursor and data management object that you can't do with an RV
3 - My SPT cursors will be faster on reads (thanks to less netwrok traffic and stored procs) and equal to RVs on writes (views are nothing but wrappers around SPT cursors anyway)
<<
Thank you for your comments about SPT. I'm not sure why you refer to SPT when I was talking about SP.
>>all other arguments aside - this is enough reason ... I swear - some people would argue that the sky is green just because they can't see blue ...<<
Quite.
Regards
JR
"... They ne'er cared for us
yet: suffer us to famish, and their store-houses
crammed with grain; make edicts for usury, to
support usurers; repeal daily any wholesome act
established against the rich, and provide more
piercing statutes daily, to chain up and restrain
the poor. If the wars eat us not up, they will; and
there's all the love they bear us."
-- Shakespeare: Coriolanus, Act 1, scene 1