That doesn't seem to want to work, although is is along the same lines as what I was originally trying.
I oringally started with the idea of a DO/While loop where if a record met the parameters, a variable called "numCount" would increase by 1. However, it appears that there is no EOF or no...
Using 8.5 against a SQL Database.
Sample Data:
QTEID# STATUSID# EFFDTE MKTID#
12345 DCU 06/01/2004 R0112
(QTEID# is an unique key identifier)
Need to count the number of QTEID#'s that occur within a time frame (select between two dates on the EFFDTE column) that possess a...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.