Answer: How to write a cursor inside a stored procedure in SQL Server 2008

answer re: How to write a cursor inside a stored procedure in SQL Server 2008

Nov 22 '12

13

Try the following snippet. You can call the the below stored procedure from your application, so that NoOfUses in the coupon table will be updated.

CREATE PROCEDURE [dbo].[sp_UpdateCouponCount]
AS

Declare     @couponCount int,
            @CouponName nvarchar(50),
            @couponIdFromQuery int


Declare curP cursor For

  select COUNT(*) as totalcount , Name as name,couponuse.couponid  as couponid

…

Open Full Answer