🚀 go-pugleaf

Bill Todd wrote:
> Ok, I am lost.
> 
> 1) What database are you using?
> 
> 2) What is PROPERCASESTRING?
> 
> 3) What does the query in your latest message have to do with the
> question and example in your first message. I cannot see any connection.
> 
> 4) What is your real question?
> 


HI:

    Thanks. The SP that this is from iterates through the records and 
returns the data into TIBSQL and from that a delimited output for upload 
to website.

1) IB 6


2) UDF that lowercases string and uppercase first letter. similar to 
f_propercase I guess.


3)  My query returns mostly one record where the latest d1 and latest d2 
I am after is in the same record. The problem is when the d1 is in one 
record and the d2 is in a different record same Id. One will be in 2007 
record and the other in 2008 record, for instance. In this case I want 
to return

CAST(m."RENEW_DTE" AS VARCHAR(10)) from the 2007 record and
CAST(m2."CRDRPT_RNW" AS VARCHAR(10))  from  the 2008 record.

or or the reverse depending on which account was due first.

4) See 3 above.