수정 좀 했더니 돌아가긴 하는데요...
문제는 없을까 몰라요...

DECLARE @stroid char(60),@oid char(40),@addpoint int, @member int

DECLARE tbOrder_cursor CURSOR FOR
select '주문 적립금 ('+order_date+seq+')' as stroid,order_date+seq as oid,addpoint, member from tbOrder where registdate < dateadd(hour, -24, getdate())  AND registdate > dateadd(hour, -48, getdate())

OPEN tbOrder_cursor

FETCH NEXT FROM tbOrder_cursor
INTO @stroid,@oid,@addpoint, @member

WHILE @@FETCH_STATUS = 0
BEGIN
if @member IS NOT NULL and @addpoint>0
 BEGIN
     update tbOrder set state=5 ,completedate=getdate() where state = 4 and order_date+seq=@oid
     exec csp_setPoint @member, 1, @addpoint, @oid
     exec csp_setMPoint @member, 1,  @addpoint
 END
  
   FETCH NEXT FROM tbOrder_cursor
   INTO @stroid,@oid,@addpoint, @member

END

CLOSE tbOrder_cursor
DEALLOCATE tbOrder_cursor
GO