Prueba con un Case :)
Código SQL:
Ver originalCREATE TABLE #temp
(
value1 VARCHAR(100),
value2 VARCHAR(100),
value3 VARCHAR(100),
value4 VARCHAR(100),
value5 VARCHAR(100),
value6 VARCHAR(100),
value7 VARCHAR(100),
value8 VARCHAR(100)
)
INSERT INTO #temp (value1,value2,value3,value4,value5,value6,value7,value8) VALUES ('0000000001','1','000001','01/01/2011','01/01/2011','ninguna','000001','01/01/2011')
INSERT INTO #temp (value1,value2,value3,value4,value5,value6,value7,value8) VALUES ('0000000002','0','000001','01/01/2011','01/01/2011','ninguna','000001','01/01/2011')
INSERT INTO #temp (value1,value2,value3,value4,value5,value6,value7,value8) VALUES ('0000000003','2','000001','01/01/2011','01/01/2011','ninguna','000001','01/01/2011')
SELECT value1,CASE
WHEN value2=1 THEN 'registrado'
WHEN value2=0 THEN 'Grabado'
WHEN value2=2 THEN 'Anulado'
END value2, value3, value4,value5,value6,value7,value8 FROM #temp
Saludos!!