SQLize Online / PHPize Online  /  SQLtest Online

USE [iRED] GO /****** Object: View [dbo].[RawDataChannelName] Script Date: 5/4/2023 8:08:48 AM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO ALTER VIEW [dbo].[RawDataChannelName] AS SELECT DISTINCT ltrim([dbo].[ClearNumericCharacters](ProgramName)) AS ChannelName, dbo.IRManualQuestions.SessionUid, dbo.IRManualQuestions.Bottler FROM dbo.IRManualQuestions WHERE dbo.IRManualQuestions.ProgramName IS NOT NULL AND CONCAT(YEAR(LastModifiedTime),MONTH(LastModifiedTime))=CONCAT(YEAR(GETDATE()),MONTH(GETDATE())) AND dbo.IRManualQuestions.SessionUid NOT IN (SELECT DISTINCT SessionUid FROM DeacitvateSessions) AND Bottler NOT LIKE 'CCBAKE' /* EXCEPT SELECT DISTINCT ltrim([dbo].[ClearNumericCharacters](ProgramName)) AS ChannelName, dbo.IRManualQuestions.SessionUid, dbo.IRManualQuestions.Bottler FROM dbo.IRManualQuestions WHERE SessionUid in ( '16840d40-79d5-4aa1-8a08-7a1054a7b0df', '205e1b04-a0e9-4cfe-ae24-a2e4abe7d798', '3a47dfc7-7730-4416-abb1-e1dc03c4aaa6', '3e22882e-76c1-46dd-9ef5-b0bf9b743c42', '502f3517-8bfb-48de-be72-a33d567fd7bb', '512868ba-b17e-4b9e-86d7-eba922c773df', '6a7f7bac-d9ca-4b09-9ab2-c1660943e5f0', '7cff6598-3b87-4095-8888-932b436c0a5b', '7d6a3d5d-d991-42ae-8d02-b172374ee6a3', '9a0a15ee-138e-4c4c-8a1c-3bcf5927b7fe', 'a058af33-825b-41a7-9c1d-73538e7847b6', 'a99d17b5-c93d-4dec-9f0e-806ba20e1bf1', 'c2cc2653-a231-4e89-a44d-cf697c9fbd14', 'd02ce1fc-9fe2-4989-a0d0-8c1d0b52b865', 'd3616255-9a53-4ec3-b450-8293fed9b7cf', 'd98fa66e-2d95-46b0-8122-ef989369a312', 'dbf0c9e8-6d89-48c1-a797-dc2f19146928', 'dcb0b340-49f5-483b-82c0-6c4a530f4073', 'dcd796d8-4e29-459b-a47a-b5b4c71e6271', 'eacfd291-2bcd-4846-9225-a2b15ed5cea1', 'f7dc2e1b-e034-4491-8b79-57f728c15c39', 'fc3ec6d1-a7fc-47b4-95e0-71fc7937cb0e', 'fcddc1cf-a9f3-4c2b-843d-feab8e435c83' ) and [ProgramName]= 'National Supermarket North' */ GO