Untitled

 avatar
unknown
plain_text
a month ago
8.7 kB
3
Indexable
(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