>Token unknown - line 5, column 1
>TMP2

Sorry, CTEs should be separated with a comma (and you don't need to cast if using constants, only if using parameters):

WITH TMP1 (CBK, INO) AS
(SELECT 'A', 2 FROM RDB$DATABASE),
TMP2 (dValueFrom, dValueTo) ...

HTH,
Set

Thanks a lot Set.  I was not aware of the requirement of the comma.  I have not been introduced by you to CROSS JOIN too, thanks there have been cases where I have used 1 = 1 to get the joined data.

Kind regards
Bhavbhuti