Is there any way that I can use a Case statement in a multi-statement table-valued function? I have a function that I am creating that will return a table with values that are calculated differently based on certain conditions. I would rather not write a different function for every possibility. I keep getting syntax errors with everything I try to do. Any ideas?
