SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE VIEW dbo.vw12Maanden
AS
SELECT     TOP 100 PERCENT LOGTIME, TAGNAME, TAGVALUE
FROM         dbo.FLOATVAL
WHERE     (TAGVALUE <> 0)
ORDER BY LOGTIME DESC

GO