Untitled
(dbo.[TG__GetDynamicTableResponseCount]('A1 Management Commitment', 'Grade', 14, [SupplierAudit].[ID], 'Major'))+ (dbo.[TG__GetDynamicTableResponseCount]('A2 Document and Record Control System', 'Grade', 14, [SupplierAudit].[ID], 'Major'))+ (dbo.[TG__GetDynamicTableResponseCount]('A3 Regulatory Compliance', 'Grade', 14, [SupplierAudit].[ID], 'Major'))+ (dbo.[TG__GetDynamicTableResponseCount]('A4 System Verification/ Internal audits', 'Grade', 14, [SupplierAudit].[ID], 'Major'))+ (dbo.[TG__GetDynamicTableResponseCount]('A5 Customer Complaints Procedure', 'Grade', 14, [SupplierAudit].[ID], 'Major'))+ (dbo.[TG__GetDynamicTableResponseCount]('A6 Management of Serious issues', 'Grade', 14, [SupplierAudit].[ID], 'Major'))+ (dbo.[TG__GetDynamicTableResponseCount]('A7 Training Programme', 'Grade', 14, [SupplierAudit].[ID], 'Major'))+ (dbo.[TG__GetDynamicTableResponseCount]('A8 Food Safety Culture', 'Grade', 14, [SupplierAudit].[ID], 'Major'))+ (dbo.[TG__GetDynamicTableResponseCount]('B1 HACCP', 'Grade', 14, [SupplierAudit].[ID], 'Major'))+ (dbo.[TG__GetDynamicTableResponseCount]('B2 GMP', 'Grade', 14, [SupplierAudit].[ID], 'Major'))+ (dbo.[TG__GetDynamicTableResponseCount]('B3 Facility', 'Grade', 14, [SupplierAudit].[ID], 'Major'))+ (dbo.[TG__GetDynamicTableResponseCount]('B4 Receiving, Storage and Distribution', 'Grade', 14, [SupplierAudit].[ID], 'Major'))+ (dbo.[TG__GetDynamicTableResponseCount]('B5 GLP', 'Grade', 14, [SupplierAudit].[ID], 'Major'))+ (dbo.[TG__GetDynamicTableResponseCount]('B6 Cleaning & Sanitation', 'Grade', 14, [SupplierAudit].[ID], 'Major'))+ (dbo.[TG__GetDynamicTableResponseCount]('B7 Pest Management', 'Grade', 14, [SupplierAudit].[ID], 'Major'))+ (dbo.[TG__GetDynamicTableResponseCount]('B8 Product Control', 'Grade', 14, [SupplierAudit].[ID], 'Major'))+ (dbo.[TG__GetDynamicTableResponseCount]('B9 Food Fraud', 'Grade', 14, [SupplierAudit].[ID], 'Major'))+ (dbo.[TG__GetDynamicTableResponseCount]('B10 Food Defense', 'Grade', 14, [SupplierAudit].[ID], 'Major'))+ (dbo.[TG__GetDynamicTableResponseCount]('B11 Traceability', 'Grade', 14, [SupplierAudit].[ID], 'Major')) (dbo.[TG__GetDynamicTableResponseCount]('A1 Management Commitment', 'Grade', 14, [SupplierAudit].[ID], 'Minor'))+ (dbo.[TG__GetDynamicTableResponseCount]('A2 Document and Record Control System', 'Grade', 14, [SupplierAudit].[ID], 'Minor'))+ (dbo.[TG__GetDynamicTableResponseCount]('A3 Regulatory Compliance', 'Grade', 14, [SupplierAudit].[ID], 'Minor'))+ (dbo.[TG__GetDynamicTableResponseCount]('A4 System Verification/ Internal audits', 'Grade', 14, [SupplierAudit].[ID], 'Minor'))+ (dbo.[TG__GetDynamicTableResponseCount]('A5 Customer Complaints Procedure', 'Grade', 14, [SupplierAudit].[ID], 'Minor'))+ (dbo.[TG__GetDynamicTableResponseCount]('A6 Management of Serious issues', 'Grade', 14, [SupplierAudit].[ID], 'Minor'))+ (dbo.[TG__GetDynamicTableResponseCount]('A7 Training Programme', 'Grade', 14, [SupplierAudit].[ID], 'Minor'))+ (dbo.[TG__GetDynamicTableResponseCount]('A8 Food Safety Culture', 'Grade', 14, [SupplierAudit].[ID], 'Minor'))+ (dbo.[TG__GetDynamicTableResponseCount]('B1 HACCP', 'Grade', 14, [SupplierAudit].[ID], 'Minor'))+ (dbo.[TG__GetDynamicTableResponseCount]('B2 GMP', 'Grade', 14, [SupplierAudit].[ID], 'Minor'))+ (dbo.[TG__GetDynamicTableResponseCount]('B3 Facility', 'Grade', 14, [SupplierAudit].[ID], 'Minor'))+ (dbo.[TG__GetDynamicTableResponseCount]('B4 Receiving, Storage and Distribution', 'Grade', 14, [SupplierAudit].[ID], 'Minor'))+ (dbo.[TG__GetDynamicTableResponseCount]('B5 GLP', 'Grade', 14, [SupplierAudit].[ID], 'Minor'))+ (dbo.[TG__GetDynamicTableResponseCount]('B6 Cleaning & Sanitation', 'Grade', 14, [SupplierAudit].[ID], 'Minor'))+ (dbo.[TG__GetDynamicTableResponseCount]('B7 Pest Management', 'Grade', 14, [SupplierAudit].[ID], 'Minor'))+ (dbo.[TG__GetDynamicTableResponseCount]('B8 Product Control', 'Grade', 14, [SupplierAudit].[ID], 'Minor'))+ (dbo.[TG__GetDynamicTableResponseCount]('B9 Food Fraud', 'Grade', 14, [SupplierAudit].[ID], 'Minor'))+ (dbo.[TG__GetDynamicTableResponseCount]('B10 Food Defense', 'Grade', 14, [SupplierAudit].[ID], 'Minor'))+ (dbo.[TG__GetDynamicTableResponseCount]('B11 Traceability', 'Grade', 14, [SupplierAudit].[ID], 'Minor')) (dbo.[TG__GetDynamicTableResponseCount]('A1 Management Commitment', 'Grade', 14, [SupplierAudit].[ID], 'Critical'))+ (dbo.[TG__GetDynamicTableResponseCount]('A2 Document and Record Control System', 'Grade', 14, [SupplierAudit].[ID], 'Critical'))+ (dbo.[TG__GetDynamicTableResponseCount]('A3 Regulatory Compliance', 'Grade', 14, [SupplierAudit].[ID], 'Critical'))+ (dbo.[TG__GetDynamicTableResponseCount]('A4 System Verification/ Internal audits', 'Grade', 14, [SupplierAudit].[ID], 'Critical'))+ (dbo.[TG__GetDynamicTableResponseCount]('A5 Customer Complaints Procedure', 'Grade', 14, [SupplierAudit].[ID], 'Critical'))+ (dbo.[TG__GetDynamicTableResponseCount]('A6 Management of Serious issues', 'Grade', 14, [SupplierAudit].[ID], 'Critical'))+ (dbo.[TG__GetDynamicTableResponseCount]('A7 Training Programme', 'Grade', 14, [SupplierAudit].[ID], 'Critical'))+ (dbo.[TG__GetDynamicTableResponseCount]('A8 Food Safety Culture', 'Grade', 14, [SupplierAudit].[ID], 'Critical'))+ (dbo.[TG__GetDynamicTableResponseCount]('B1 HACCP', 'Grade', 14, [SupplierAudit].[ID], 'Critical'))+ (dbo.[TG__GetDynamicTableResponseCount]('B2 GMP', 'Grade', 14, [SupplierAudit].[ID], 'Critical'))+ (dbo.[TG__GetDynamicTableResponseCount]('B3 Facility', 'Grade', 14, [SupplierAudit].[ID], 'Critical'))+ (dbo.[TG__GetDynamicTableResponseCount]('B4 Receiving, Storage and Distribution', 'Grade', 14, [SupplierAudit].[ID], 'Critical'))+ (dbo.[TG__GetDynamicTableResponseCount]('B5 GLP', 'Grade', 14, [SupplierAudit].[ID], 'Critical'))+ (dbo.[TG__GetDynamicTableResponseCount]('B6 Cleaning & Sanitation', 'Grade', 14, [SupplierAudit].[ID], 'Critical'))+ (dbo.[TG__GetDynamicTableResponseCount]('B7 Pest Management', 'Grade', 14, [SupplierAudit].[ID], 'Critical'))+ (dbo.[TG__GetDynamicTableResponseCount]('B8 Product Control', 'Grade', 14, [SupplierAudit].[ID], 'Critical'))+ (dbo.[TG__GetDynamicTableResponseCount]('B9 Food Fraud', 'Grade', 14, [SupplierAudit].[ID], 'Critical'))+ (dbo.[TG__GetDynamicTableResponseCount]('B10 Food Defense', 'Grade', 14, [SupplierAudit].[ID], 'Critical'))+ (dbo.[TG__GetDynamicTableResponseCount]('B11 Traceability', 'Grade', 14, [SupplierAudit].[ID], 'Critical')) SELECT (dbo.[TG__GetDynamicTableResponseCount]('A1 Management Commitment', 'Grade', 14, [SupplierAudit].[ID], 'Critical')+ dbo.[TG__GetDynamicTableResponseCount]('A2 Document and Record Control System', 'Grade', 14, [SupplierAudit].[ID], 'Critical')+ dbo.[TG__GetDynamicTableResponseCount]('A3 Regulatory Compliance', 'Grade', 14, [SupplierAudit].[ID], 'Critical')+ dbo.[TG__GetDynamicTableResponseCount]('A4 System Verification/ Internal audits', 'Grade', 14, [SupplierAudit].[ID], 'Critical')+ dbo.[TG__GetDynamicTableResponseCount]('A5 Customer Complaints Procedure', 'Grade', 14, [SupplierAudit].[ID], 'Critical')+ dbo.[TG__GetDynamicTableResponseCount]('A6 Management of Serious issues', 'Grade', 14, [SupplierAudit].[ID], 'Critical')+ dbo.[TG__GetDynamicTableResponseCount]('A7 Training Programme', 'Grade', 14, [SupplierAudit].[ID], 'Critical')+ dbo.[TG__GetDynamicTableResponseCount]('A8 Food Safety Culture', 'Grade', 14, [SupplierAudit].[ID], 'Critical')+ dbo.[TG__GetDynamicTableResponseCount]('B1 HACCP', 'Grade', 14, [SupplierAudit].[ID], 'Critical')+ dbo.[TG__GetDynamicTableResponseCount]('B2 GMP', 'Grade', 14, [SupplierAudit].[ID], 'Critical')+ dbo.[TG__GetDynamicTableResponseCount]('B3 Facility', 'Grade', 14, [SupplierAudit].[ID], 'Critical')+ dbo.[TG__GetDynamicTableResponseCount]('B4 Receiving, Storage and Distribution', 'Grade', 14, [SupplierAudit].[ID], 'Critical')+ dbo.[TG__GetDynamicTableResponseCount]('B5 GLP', 'Grade', 14, [SupplierAudit].[ID], 'Critical')+ dbo.[TG__GetDynamicTableResponseCount]('B6 Cleaning & Sanitation', 'Grade', 14, [SupplierAudit].[ID], 'Critical')+ dbo.[TG__GetDynamicTableResponseCount]('B7 Pest Management', 'Grade', 14, [SupplierAudit].[ID], 'Critical')+ dbo.[TG__GetDynamicTableResponseCount]('B8 Product Control', 'Grade', 14, [SupplierAudit].[ID], 'Critical')+ dbo.[TG__GetDynamicTableResponseCount]('B9 Food Fraud', 'Grade', 14, [SupplierAudit].[ID], 'Critical')+ dbo.[TG__GetDynamicTableResponseCount]('B10 Food Defense', 'Grade', 14, [SupplierAudit].[ID], 'Critical')+ dbo.[TG__GetDynamicTableResponseCount]('B11 Traceability', 'Grade', 14, [SupplierAudit].[ID], 'Critical')) As Total FROM [SupplierAudit];
Leave a Comment