Table have columns OpenAmount, Period 1, Period2, Period3.... so on.
I need to write SELECT statement that will require Period input runtime.
If entered value=1
OpenAmount + Period1
If entered value=2
OpenAmount + Period1+Period2
If entered value=3
OpenAmount + Period1+Period2+Period3
I am using openrowset