cursor in Stored Procedures

[hariharanmca]

any one Explain me the details about Cursors in Stored Procedures and is there any other way to call views in stored Procedure

[hariharanmca]

any one Explain me the details about Cursors in Stored Procedures and is there any other way to call views in stored Procedure

Its very Urgent, If i simply write select * from vw_viewName then its giving Error like


Error:
=================================
Server: Msg 8624, Level 16, State 16, Procedure sp_Add_Remove_ItemQtyForNonChargeOrder , Line 18
Internal SQL Server error.



Line 18 is select * from vw_viewName

[almaz]

See problem description here.