SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

CREATE VIEW dbo.VW_SCHAKEL_WEEK
AS
SELECT     TOP 100 PERCENT [TIME], SCHAKELTEKST1, SCHAKELTEKST2, SCHAKELTEKST3, SCHAKELTEKST4, RAPPORTDAG
FROM         dbo.RAP_SCHAKEL
WHERE     (dbo.DAGPERIODE(FLTIME, GETDATE()) = 1)
ORDER BY [TIME] DESC


GO