Hallo!

Try to redefine a task:

First: I think you do not have to SELECT *

Second:

 Rewrite code as:

DECLARE @I INT

SET @I = 1

SELECT

    A.*

    ,specificField =

      CASE

        WHEN @i =...

I'm also a little confused about examples.

I think it will be more interesting to rewrite all examples with indexed view (possible in 2K)

Hint will be awailable, speed of insert/update/delete is...

This must be in BOL IMUO (In My UNHonest Opinion)