Enterprise to Cameron Report Conversion
Posted: Tue Jun 30, 2015 6:54 pm
Good evening,
I am trying to find where in the Cameron Database would I find the "Type" as indicated in the code below from Enterprise?
From what I can tell, it does not exist.
from policyregister t3
left outer join search t1 on t1.firmfile = t3.firmfile
where
t3.firmfile in (select firmfile from #policiesissued) and
t3.type in ('L-OE', 'F-L1E', 'I-L2E', 'L-L3E')
Thank you,
Colin.
I am trying to find where in the Cameron Database would I find the "Type" as indicated in the code below from Enterprise?
From what I can tell, it does not exist.
from policyregister t3
left outer join search t1 on t1.firmfile = t3.firmfile
where
t3.firmfile in (select firmfile from #policiesissued) and
t3.type in ('L-OE', 'F-L1E', 'I-L2E', 'L-L3E')
Thank you,
Colin.