Why You don't use UDP
exaple:
a = 0
SELECT Incrase(@a) AS exp1, column1 from table

FUNCTION Incrase
PARAMETER a
a = a +1
return a

Mark