The speed will pretty much be the same as they both rely on SQL SELECT. The biggest difference is a view is generally updateable. You can make a read/write cursor, but you have to write your own update code. With a view, you just do a TABLEUPDATE().
>i want to know what is the difference between a view and a cursor?
>
>
>Wich one is the faster ?
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer
