SELECT E.Name0, E.UserName0, E.VariableValue0
FROM dbo.v_GS_ENVIRONMENT E
WHERE (E.Name0=’TMP’)
ORDER BY E.Name0