SELECT [Vw_LicenceCancelDetails].[LicenceCancelDetailID] AS [LicenceCancelDetailID], [Vw_LicenceCancelDetails].[OfficeLocationID] AS [OfficeLocationID], [Vw_LicenceCancelDetails].[WorkflowInstanceID] AS [WorkflowInstanceID], [Vw_LicenceCancelDetails].[LicenceCancelNumber] AS [LicenceCancelNumber], [Vw_LicenceCancelDetails].[OperatingLicenceNumber] AS [OperatingLicenceNumber], [Vw_LicenceCancelDetails].[DateOfIssue] AS [DateOfIssue], [Vw_LicenceCancelDetails].[DateOfExpiry] AS [DateOfExpiry], [Vw_LicenceCancelDetails].[NameOnLicence] AS [NameOnLicence], [Vw_LicenceCancelDetails].[CertificateNumber] AS [CertificateNumber], [Vw_LicenceCancelDetails].[LicenceStatus] AS [LicenceStatus] FROM [App].[Vw_LicenceCancelDetails] AS [Vw_LicenceCancelDetails] [ScriptIgnore] [ScriptIgnore]