# example script to create View in db storage:

CREATE VIEW \[dbo].\[<mark style="background-color:green;">CS\_ItemMaster</mark>] AS

SELECT ItemNumber, ItemTitle, ItemDetail, units, CategoryName, IsConsumable, IsObsolete, <mark style="background-color:orange;">CONVERT(NVARCHAR(10), (SELECT TOP (1) Value FROM dbo.Property AS P WHERE (EntityID=dbo.vw\_ItemRevision.ItemIterationID) AND (PropertyDefID=166)) AS TpvZm</mark>&#x20;

FROM dbo.vw\_ItemRevision WHERE (ItemIterationID IN (SELECT MAX(ItemIterationID) AS E1 FROM dbo.vw\_ItemIteration AS I1 GROUP BY itemMasterID))