True, main reason is because of about 15 "if" statements I have to do based on the selection of a drop down in the list.
I have a column named "Media Type", in the column there are several options. Daily Newspaper, Weekly Newspaper, Blog, Web Site, Newsletter, Radio and Television.
There is also a column called "Circulation".
I need to calculate this:
If Daily Newspaper selected, multiply Circulation by 2.6
If Weekly Newspaper selected, multiply Circulation by 2.2
If Radio selected, multiply Circulation by 2.7
All rest get multiplied by 1.
I am not a SQL pro, any suggestions would be great.
Thanks in advance!