FUNCTION fGetQualityEvents

Returns table of quality events for a specific @quality.

Up to eight different events can be returned, depending on the given quality flag.

returned table:

event text NOT NULL, -- Quality event

severity varchar(15) NOT NULL, -- Information, Warning or Severe defect

comments text NOT NULL -- Description of the consequences of the event.

Sample call to find all the quality events, having the quality flag equal to 1040.
SELECT * FROM dbo.fGetQualityEvents(1040)

Name Type Length inout pnum

@quality int 4 input 1

event text -1 output 1

severity varchar 15 output 2

comments text -1 output 3

Name	Type	Length	inout	pnum
@quality	int	4	input	1
event	text	-1	output	1
severity	varchar	15	output	2
comments	text	-1	output	3