USE [ISInfoPool]
GO
/****** Object:  View [dbo].[SFA_view_by_sort]    Script Date: 10/16/2008 17:34:44 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER VIEW [dbo].[SFA_view_by_sort]
AS
SELECT        SFA_FDName,SFA_ComputerName, SFA_FDPermission, SFA_FDOwner,RIGHT(SFA_FDOwner,6) AS FDOwner, SFA_FDCreateTime, SFA_SystemTime
FROM        dbo.SF_Audit
WHERE      SFA_FDOwner like ('inotera\%') and LEN(SFA_FDOwner) = '14' and
CONVERT(VARCHAR(10),SFA_SystemTime,111) = CONVERT(VARCHAR(10),GETDATE()-1,111)
ORDER BY FDOwner