Cursor add condition
Yes I want to add a condition to my cursor if a row returns blank skip and show the rows that are not blank.
OPEN tblcur
FETCH NEXT FROM tblcur INTO @tbl
WHILE @@FETCH_STATUS = 0
BEGIN
EXEC GetInvoice @tbl, @Customer
FETCH NEXT FROM tblcur INTO @tbl
END
close tblcur
OPEN tblcur
FETCH NEXT FROM tblcur INTO @tbl
WHILE @@FETCH_STATUS = 0
BEGIN
EXEC GetInvoice @tbl, @Customer
FETCH NEXT FROM tblcur INTO @tbl
END
close tblcur
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER