flog

Space bucks ain't worth shit in this 'conomy. I need Plutonian Fluxors for me to budge.

PayUp(x)
{
return (x + 8) % 8 - 1;
}

NOt quite there, but close. There's got to be a way.

Nothing occurred to me in my sleep beyond the straightforward
FunTimes(x)
{
return (x == 1 ? 7 : x - 1)
}

I'm afraid all I have access to on my paltry code monkey salary is space bucks - no Plutonian Fluxors for you.

Steve's suggestions with the tertiary operator and IIF() pointed me to the function below. The question is whether a CASE statement is less ugly than an IF. It is technically a single line which I like better for some stupid aesthetic reason.

CREATE FUNCTION dbo.fx
(
  @x int
)
RETURNS int
AS
BEGIN
  DECLARE @y int
  
  SET @y = CASE @x WHEN 1 THEN 7 ELSE @x - 1 END

  RETURN @y
END