Dear All,

I have made below routine for getting next number where cursor is
created.
Is there any way short way like if exist(select..) through I can get
next number?
Please help.

DECLARE @FISPRD AS VARCHAR(6)
SET @FISPRD = @FISNO + LEFT(@PRD, 2)
DECLARE @VNORETURN INT
DECLARE @VNO INT
DECLARE @NTOCVNO VARCHAR(4)
SET @VNORETURN = 0
--DECLARE CURSOR
DECLARE VNO_CURSOR CURSOR LOCAL SCROLL STATIC
FOR
SELECT RIGHT(VNO,4) FROM GLTRAN_MF WHERE BRNCODE = @BRNCODE AND VTYPE =
@VTYPE AND
LEFT(VNO,5) = @FISPRD ORDER BY VNO DESC
OPEN VNO_CURSOR
FETCH NEXT FROM VNO_CURSOR INTO @NTOCVNO
IF @@CURSOR_ROWS = 0
SET @NTOCVNO = '0'
CLOSE VNO_CURSOR
DEALLOCATE VNO_CURSOR
--CLOSE CURSOR
SET @VNO = @NTOCVNO
SELECT @NTOCVNO = DBO.NTOC(@VNO+1)
SET @PRD = LEFT(@PRD,2) + @NTOCVNO

Regards,
Siddique

--
This message has been scanned for viruses and
dangerous content by MailScanner, and is
believed to be clean.


MS Sql Server LazyDBA home page