Views allow you to logically organize applications into groups. For example you may want a view that will show you all the applications that are produced by a particular manufacturer. In this demo I will show you how to create a dynamic view grouping all application by their manufacturer. You will need the SQL code at the bottom of this post.

CREATE PROCEDURE [dbo].[prViewByManufacturer]

@GroupName varchar(255)

AS

DECLARE @ReportId varchar(36)

SELECT @ReportId = ReportId FROM tblReportDefinitions WHERE GroupName = @GroupName

SELECT

'' AS 'PackageTitle',

m.Author AS 'IssueData',

';;' AS 'IssueData2',

'View Generation' AS 'Fix',

'Amber' AS 'RAGStatus',

'Info' AS 'RAGType',

'Empty' AS 'FixType',

'Empty' AS 'FixData',

m.UUID AS 'UUID'

FROM tblmsiMetaData m

Anonymous
Related Content