Need help with cursor or while loop in scripted cal view
I have Table A
CLIENT AGREEMENT_NO EMPNO STARTYEAR ENDYEAR TYPE QTY MODEL TOTAL_AMT NET AMT 100 1234 10000 2009 2018 ABC 20,000 MODEL7 30,000 5,000 100 1234 10000 2009 2018 NON 5,000 MODEL7 30,000 5,000 100 1234 10000 2009 2018 XYZ 20,000 MODEL7 30,000 5,000 100 1234 10000 2009 2018 DDD 5,000 MODEL7 30,000 5,000I have Table B
FSCYEARSTR 2000 2001 2002 2003 2004 2005 2006 2007 2008 2009 2010 2011 2012 2013 2014 2015 2016 2017 2018 2019 2020 2021 2022 2023 2024 2025 2026 2027 2028 2029 2030Need following result;
CLIENT FSCYEARSTR AGREEMENT_NO EMPNO STARTYEAR ENDYEAR TYPE QTY MODEL TOTAL_AMT NET AMT 100 2009 1234 10000 2009 2018 ABC 20,000 MODEL7 30,000 5,000 100 2010 1234 10000 2009 2018 ABC 20,000 MODEL7 30,000 5,000 100 2011 1234 10000 2009 2018 ABC 20,000 MODEL7 30,000 5,000 100 2012 1234 10000 2009 2018 ABC 20,000 MODEL7 30,000 5,000 100 2013 1234 10000 2009 2018 ABC 20,000 MODEL7 30,000 5,000 100 2014 1234 10000 2009 2018 ABC 20,000 MODEL7 30,000 5,000 100 2015 1234 10000 2009 2018 ABC 20,000 MODEL7 30,000 5,000 100 2016 1234 10000 2009 2018 ABC 20,000 MODEL7 30,000 5,000 100 2017 1234 10000 2009 2018 ABC 20,000 MODEL7 30,000 5,000 100 2018 1234 10000 2009 2018 NON 5,000 MODEL7 30,000 5,000 100 2009 1234 10000 2009 2018 NON 5,000 MODEL7 30,000 5,000 100 2010 1234 10000 2009 2018 NON 5,000 MODEL7 30,000 5,000 100 2011 1234 10000 2009 2018 NON 5,000 MODEL7 30,000 5,000 100 2012 1234 10000 2009 2018 NON 5,000 MODEL7 30,000 5,000 100 2013 1234 10000 2009 2018 NON 5,000 MODEL7 30,000 5,000 100 2014 1234 10000 2009 2018 NON 5,000 MODEL7 30,000 5,000 100 2015 1234 10000 2009 2018 NON 5,000 MODEL7 30,000 5,000 100 2016 1234 10000 2009 2018 NON 5,000 MODEL7 30,000 5,000 100 2017 1234 10000 2009 2018 NON 5,000 MODEL7 30,000 5,000 100 2018 1234 10000 2009 2018 NON 5,000 MODEL7 30,000 5,000 100 2009 1234 10000 2009 2018 XYZ 20,000 MODEL7 30,000 5,000 100 2010 1234 10000 2009 2018 XYZ 20,000 MODEL7 30,000 5,000 100 2011 1234 10000 2009 2018 XYZ 20,000 MODEL7 30,000 5,000 100 2012 1234 10000 2009 2018 XYZ 20,000 MODEL7 30,000 5,000 100 2013 1234 10000 2009 2018 XYZ 20,000 MODEL7 30,000 5,000 100 2014 1234 10000 2009 2018 XYZ 20,000 MODEL7 30,000 5,000 100 2015 1234 10000 2009 2018 XYZ 20,000 MODEL7 30,000 5,000 100 2016 1234 10000 2009 2018 XYZ 20,000 MODEL7 30,000 5,000 100 2017 1234 10000 2009 2018 XYZ 20,000 MODEL7 30,000 5,000 100 2018 1234 10000 2009 2018 DDD 5,000 MODEL7 30,000 5,000 100 2009 1234 10000 2009 2018 DDD 5,000 MODEL7 30,000 5,000 100 2010 1234 10000 2009 2018 DDD 5,000 MODEL7 30,000 5,000 100 2011 1234 10000 2009 2018 DDD 5,000 MODEL7 30,000 5,000 100 2012 1234 10000 2009 2018 DDD 5,000 MODEL7 30,000 5,000 100 2013 1234 10000 2009 2018 DDD 5,000 MODEL7 30,000 5,000 100 2014 1234 10000 2009 2018 DDD 5,000 MODEL7 30,000 5,000 100 2015 1234 10000 2009 2018 DDD 5,000 MODEL7 30,000 5,000 100 2016 1234 10000 2009 2018 DDD 5,000 MODEL7 30,000 5,000 100 2017 1234 10000 2009 2018 DDD 5,000 MODEL7 30,000 5,000 100 2018 1234 10000 2009 2018 DDD 5,000 MODEL7 30,000 5,000I can use Cartesian join in graphical calculation view but then i will compromise on performance, please help.