mandania (7/3/2015)
I get this error.Operand type clash: int is incompatible with date.My subscription table has around more that 20,000 subscriptionids. I have rownum so that i can concatenate this rownumber to my subscription id i.e 213123_1,213123_2 etc..etc.. and same with subscriptionrowdate i add a month for everysubscriptionid 2007-01-01, 2007-02-01,2007-03-01...2039-04-01 but this is not what i want. Currently my code is generating this date based on rownum which is wrong, i want to break when
datediff(day, salesdate, baseenddate) is reaches 0 and move on to next subscriptionid.
My bad. I used some lazy programming expecting datetime instead of date. Change the "0" to '1900-01-01' or some representation on missing/invalid data.
else '1900-01-01' end as subscriptionrowdate
Don Simpson