USE [ISInfoPool]
GO
/****** Object:  View [dbo].[SSQL00_NEmployee_Email_v]    Script Date: 10/16/2008 17:34:29 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER VIEW [dbo].[SSQL00_NEmployee_Email_v]
AS

SELECT     
--Id_No, E_Mail -- for production
ID_no, 'lancelothsu@mailcc.com' AS E_Mail -- For Test
FROM         SSQL00.HRIS.dbo.NEmployee AS NEmployee_1