How do I streamline this code?

sharona · *nix forums beginner Joined: 24 Jun 2005 Posts: 6

Hi,

I have 3 blocks of code that are identical, can you tell me how to
rewrite this in a Sybase stored procedure so that I only have to write
the logic once?

SELECT @SourceRating = CASE
WHEN (@Source = "pr") THEN 3
WHEN (@Source = "qa") THEN 2
ELSE 1
END

SELECT @OwnerRating = CASE
WHEN (@AssetOwner = "pr") THEN 3
WHEN (@AssetOwner = "qa") THEN 2
ELSE 1
END

SELECT @StewardRating = CASE
WHEN (@Steward = "pr") THEN 3
WHEN (@Steward = "qa") THEN 2
ELSE 1
END

Thanks.

Carl Kayser · *nix forums beginner Joined: 25 May 2005 Posts: 42

"sharona" <shari.arman@morganstanley.com> wrote in message
news:1151325874.375626.234160@p79g2000cwp.googlegroups.com...

Google