SQL Server 2022

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE TABLE [dbo].[Events](
	[Id] [bigint] IDENTITY NOT NULL,
	CONSTRAINT [PK_Events_ID] PRIMARY KEY CLUSTERED ([Id] ASC),
	[OrderId] [nvarchar](128) NOT NULL,
	[EventGuid] [uniqueidentifier] NOT NULL,
	[EventType] [nvarchar](128) NOT NULL,
	[EventSource] [nvarchar](128) NOT NULL,
	[TransactionTime] [datetimeoffset](7) NOT NULL,
	[EventObject] [nvarchar](max) NOT NULL,
	[IsDeleted] [bit] NOT NULL,
	[CreateDate] [datetimeoffset](7) NOT NULL,
	[ModifyDate] [datetimeoffset](7) NOT NULL
)
 

ALTER TABLE [dbo].[Events] ADD CONSTRAINT [DF_Events_CreateDate] DEFAULT (getutcdate()) FOR [CreateDate]
 

ALTER TABLE [dbo].[Events] ADD CONSTRAINT [DF_Events_ModifyDate] DEFAULT (getutcdate()) FOR [ModifyDate]
 



CREATE UNIQUE INDEX IX_Events_EventGuid_Unique_Index ON [dbo].[Events] (EventGuid);
CREATE UNIQUE INDEX IX_Events_CreateDate_Unique_Index ON [dbo].[Events] (CreateDate);




CREATE TABLE [dbo].[Events](
	[Id] [bigint] IDENTITY NOT NULL,
	CONSTRAINT [PK_Events_ID] PRIMARY KEY CLUSTERED ([Id] ASC),
	[OrderId] [nvarchar](128) NOT NULL,
	[EventGuid] [uniqueidentifier] NOT NULL,
	[EventType] [nvarchar](128) NOT NULL,
	[EventSource] [nvarchar](128) NOT NULL,
	[TransactionTime] [datetimeoffset](7) NOT NULL,
	[EventObject] [nvarchar](max) NOT NULL,
	[IsDeleted] [bit] NOT NULL,
	[CreateDate] [datetimeoffset](7) NOT NULL,
	[ModifyDate] [datetimeoffset](7) NOT NULL
)
 

ALTER TABLE [dbo].[Events] ADD CONSTRAINT [DF_Events_CreateDate] DEFAULT (getutcdate()) FOR [CreateDate]
 

ALTER TABLE [dbo].[Events] ADD CONSTRAINT [DF_Events_ModifyDate] DEFAULT (getutcdate()) FOR [ModifyDate]
 


CREATE UNIQUE INDEX IX_Events_EventGuid_Unique_Index ON [dbo].[Events] (EventGuid);
CREATE UNIQUE INDEX IX_Events_CreateDate_Unique_Index ON [dbo].[Events] (CreateDate);
 
INSERT INTO [dbo].[Events] (
	OrderId
	,EventGuid
	,EventType
	,EventSource
	,TransactionTime
	,EventObject
	,IsDeleted
	,CreateDate
	,ModifyDate
	)
VALUES (
	'ABC'
	,NEWID()
	,'Approval'
	,'YOUR_MOM'
	,'2023-03-30 03:02:41.0000000 +00:00'
	,'{"DateTime": "01-01-2023", "Firstname": "Jeff", "Lastname": "Test", "Items": [{ "ItemNumber": 123, "Nested": {"Code": "XYZ" }}] } '
	,0
	,GETUTCDATE()
	,GETUTCDATE()
)
Msg 2714 Level 16 State 6 Line 1
There is already an object named 'Events' in the database.

DECLARE @start_date DATETIME = '2023-04-07 00:00:00'
DECLARE @end_date DATETIME = '2023-04-08 23:00:00'
DECLARE @hours CURSOR;
DECLARE @interval INT = 1;
-- You can adjust the to every n hour range if needed.
SET @hours = CURSOR FOR
 WITH cte_hourly_timestamps AS (
  SELECT CONVERT(datetimeoffset, @start_date) AS start_hour
  UNION ALL
  SELECT DATEADD(HOUR, @interval, start_hour)
  FROM cte_hourly_timestamps
  WHERE start_hour < CONVERT(datetimeoffset, @end_date) 
),
cte_range_timestamps AS (
	SELECT start_hour, DATEADD(HOUR, @interval, start_hour) as end_hour FROM cte_hourly_timestamps
)
SELECT * FROM cte_range_timestamps

DECLARE @sql VARCHAR(1000)

OPEN @hours
FETCH NEXT from @hours INTO @start_date, @end_date
WHILE @@fetch_status = 0
BEGIN
	--PRINT CONVERT(VARCHAR, @start_date, 120)  
	--PRINT CONVERT(VARCHAR, @end_date, 120) 

	-- Update below query to whatever suites your needs

	SET @sql = 'SELECT TOP(100) *
	  FROM [dbo].[Events] WITH (NOLOCK)
	  WHERE CreateDate BETWEEN ''' + CONVERT(VARCHAR, @start_date, 120) + ''' AND ''' + CONVERT(VARCHAR, @end_date, 120) + ''' 
	  AND EventType = ''Approval''
	  AND  JSON_VALUE(EventObject, ''$.Items[0].Nested.Code'') IS NULL'

	PRINT @sql

	-- Comment below for testing.
	EXEC (@sql)

	--BREAK;
	
    FETCH NEXT FROM @hours INTO @start_date, @end_date
END

CLOSE @hours
DEALLOCATE @hours


Id
OrderId
EventGuid
EventType
EventSource
TransactionTime
EventObject
IsDeleted
CreateDate
ModifyDate


SELECT TOP(100) *
	  FROM [dbo].[Events] WITH (NOLOCK)
	  WHERE CreateDate BETWEEN '2023-04-07 00:00:00' AND '2023-04-07 01:00:00' 
	  AND EventType = 'Approval'
	  AND  JSON_VALUE(EventObject, '$.Items[0].Nested.Code') IS NULL




Id
OrderId
EventGuid
EventType
EventSource
TransactionTime
EventObject
IsDeleted
CreateDate
ModifyDate


SELECT TOP(100) *
	  FROM [dbo].[Events] WITH (NOLOCK)
	  WHERE CreateDate BETWEEN '2023-04-07 01:00:00' AND '2023-04-07 02:00:00' 
	  AND EventType = 'Approval'
	  AND  JSON_VALUE(EventObject, '$.Items[0].Nested.Code') IS NULL




Id
OrderId
EventGuid
EventType
EventSource
TransactionTime
EventObject
IsDeleted
CreateDate
ModifyDate


SELECT TOP(100) *
	  FROM [dbo].[Events] WITH (NOLOCK)
	  WHERE CreateDate BETWEEN '2023-04-07 02:00:00' AND '2023-04-07 03:00:00' 
	  AND EventType = 'Approval'
	  AND  JSON_VALUE(EventObject, '$.Items[0].Nested.Code') IS NULL




Id
OrderId
EventGuid
EventType
EventSource
TransactionTime
EventObject
IsDeleted
CreateDate
ModifyDate


SELECT TOP(100) *
	  FROM [dbo].[Events] WITH (NOLOCK)
	  WHERE CreateDate BETWEEN '2023-04-07 03:00:00' AND '2023-04-07 04:00:00' 
	  AND EventType = 'Approval'
	  AND  JSON_VALUE(EventObject, '$.Items[0].Nested.Code') IS NULL




Id
OrderId
EventGuid
EventType
EventSource
TransactionTime
EventObject
IsDeleted
CreateDate
ModifyDate


SELECT TOP(100) *
	  FROM [dbo].[Events] WITH (NOLOCK)
	  WHERE CreateDate BETWEEN '2023-04-07 04:00:00' AND '2023-04-07 05:00:00' 
	  AND EventType = 'Approval'
	  AND  JSON_VALUE(EventObject, '$.Items[0].Nested.Code') IS NULL




Id
OrderId
EventGuid
EventType
EventSource
TransactionTime
EventObject
IsDeleted
CreateDate
ModifyDate


SELECT TOP(100) *
	  FROM [dbo].[Events] WITH (NOLOCK)
	  WHERE CreateDate BETWEEN '2023-04-07 05:00:00' AND '2023-04-07 06:00:00' 
	  AND EventType = 'Approval'
	  AND  JSON_VALUE(EventObject, '$.Items[0].Nested.Code') IS NULL




Id
OrderId
EventGuid
EventType
EventSource
TransactionTime
EventObject
IsDeleted
CreateDate
ModifyDate


SELECT TOP(100) *
	  FROM [dbo].[Events] WITH (NOLOCK)
	  WHERE CreateDate BETWEEN '2023-04-07 06:00:00' AND '2023-04-07 07:00:00' 
	  AND EventType = 'Approval'
	  AND  JSON_VALUE(EventObject, '$.Items[0].Nested.Code') IS NULL




Id
OrderId
EventGuid
EventType
EventSource
TransactionTime
EventObject
IsDeleted
CreateDate
ModifyDate


SELECT TOP(100) *
	  FROM [dbo].[Events] WITH (NOLOCK)
	  WHERE CreateDate BETWEEN '2023-04-07 07:00:00' AND '2023-04-07 08:00:00' 
	  AND EventType = 'Approval'
	  AND  JSON_VALUE(EventObject, '$.Items[0].Nested.Code') IS NULL




Id
OrderId
EventGuid
EventType
EventSource
TransactionTime
EventObject
IsDeleted
CreateDate
ModifyDate


SELECT TOP(100) *
	  FROM [dbo].[Events] WITH (NOLOCK)
	  WHERE CreateDate BETWEEN '2023-04-07 08:00:00' AND '2023-04-07 09:00:00' 
	  AND EventType = 'Approval'
	  AND  JSON_VALUE(EventObject, '$.Items[0].Nested.Code') IS NULL




Id
OrderId
EventGuid
EventType
EventSource
TransactionTime
EventObject
IsDeleted
CreateDate
ModifyDate


SELECT TOP(100) *
	  FROM [dbo].[Events] WITH (NOLOCK)
	  WHERE CreateDate BETWEEN '2023-04-07 09:00:00' AND '2023-04-07 10:00:00' 
	  AND EventType = 'Approval'
	  AND  JSON_VALUE(EventObject, '$.Items[0].Nested.Code') IS NULL




Id
OrderId
EventGuid
EventType
EventSource
TransactionTime
EventObject
IsDeleted
CreateDate
ModifyDate


SELECT TOP(100) *
	  FROM [dbo].[Events] WITH (NOLOCK)
	  WHERE CreateDate BETWEEN '2023-04-07 10:00:00' AND '2023-04-07 11:00:00' 
	  AND EventType = 'Approval'
	  AND  JSON_VALUE(EventObject, '$.Items[0].Nested.Code') IS NULL




Id
OrderId
EventGuid
EventType
EventSource
TransactionTime
EventObject
IsDeleted
CreateDate
ModifyDate


SELECT TOP(100) *
	  FROM [dbo].[Events] WITH (NOLOCK)
	  WHERE CreateDate BETWEEN '2023-04-07 11:00:00' AND '2023-04-07 12:00:00' 
	  AND EventType = 'Approval'
	  AND  JSON_VALUE(EventObject, '$.Items[0].Nested.Code') IS NULL




Id
OrderId
EventGuid
EventType
EventSource
TransactionTime
EventObject
IsDeleted
CreateDate
ModifyDate


SELECT TOP(100) *
	  FROM [dbo].[Events] WITH (NOLOCK)
	  WHERE CreateDate BETWEEN '2023-04-07 12:00:00' AND '2023-04-07 13:00:00' 
	  AND EventType = 'Approval'
	  AND  JSON_VALUE(EventObject, '$.Items[0].Nested.Code') IS NULL




Id
OrderId
EventGuid
EventType
EventSource
TransactionTime
EventObject
IsDeleted
CreateDate
ModifyDate


SELECT TOP(100) *
	  FROM [dbo].[Events] WITH (NOLOCK)
	  WHERE CreateDate BETWEEN '2023-04-07 13:00:00' AND '2023-04-07 14:00:00' 
	  AND EventType = 'Approval'
	  AND  JSON_VALUE(EventObject, '$.Items[0].Nested.Code') IS NULL




Id
OrderId
EventGuid
EventType
EventSource
TransactionTime
EventObject
IsDeleted
CreateDate
ModifyDate


SELECT TOP(100) *
	  FROM [dbo].[Events] WITH (NOLOCK)
	  WHERE CreateDate BETWEEN '2023-04-07 14:00:00' AND '2023-04-07 15:00:00' 
	  AND EventType = 'Approval'
	  AND  JSON_VALUE(EventObject, '$.Items[0].Nested.Code') IS NULL




Id
OrderId
EventGuid
EventType
EventSource
TransactionTime
EventObject
IsDeleted
CreateDate
ModifyDate


SELECT TOP(100) *
	  FROM [dbo].[Events] WITH (NOLOCK)
	  WHERE CreateDate BETWEEN '2023-04-07 15:00:00' AND '2023-04-07 16:00:00' 
	  AND EventType = 'Approval'
	  AND  JSON_VALUE(EventObject, '$.Items[0].Nested.Code') IS NULL




Id
OrderId
EventGuid
EventType
EventSource
TransactionTime
EventObject
IsDeleted
CreateDate
ModifyDate


SELECT TOP(100) *
	  FROM [dbo].[Events] WITH (NOLOCK)
	  WHERE CreateDate BETWEEN '2023-04-07 16:00:00' AND '2023-04-07 17:00:00' 
	  AND EventType = 'Approval'
	  AND  JSON_VALUE(EventObject, '$.Items[0].Nested.Code') IS NULL




Id
OrderId
EventGuid
EventType
EventSource
TransactionTime
EventObject
IsDeleted
CreateDate
ModifyDate


SELECT TOP(100) *
	  FROM [dbo].[Events] WITH (NOLOCK)
	  WHERE CreateDate BETWEEN '2023-04-07 17:00:00' AND '2023-04-07 18:00:00' 
	  AND EventType = 'Approval'
	  AND  JSON_VALUE(EventObject, '$.Items[0].Nested.Code') IS NULL




Id
OrderId
EventGuid
EventType
EventSource
TransactionTime
EventObject
IsDeleted
CreateDate
ModifyDate


SELECT TOP(100) *
	  FROM [dbo].[Events] WITH (NOLOCK)
	  WHERE CreateDate BETWEEN '2023-04-07 18:00:00' AND '2023-04-07 19:00:00' 
	  AND EventType = 'Approval'
	  AND  JSON_VALUE(EventObject, '$.Items[0].Nested.Code') IS NULL




Id
OrderId
EventGuid
EventType
EventSource
TransactionTime
EventObject
IsDeleted
CreateDate
ModifyDate


SELECT TOP(100) *
	  FROM [dbo].[Events] WITH (NOLOCK)
	  WHERE CreateDate BETWEEN '2023-04-07 19:00:00' AND '2023-04-07 20:00:00' 
	  AND EventType = 'Approval'
	  AND  JSON_VALUE(EventObject, '$.Items[0].Nested.Code') IS NULL




Id
OrderId
EventGuid
EventType
EventSource
TransactionTime
EventObject
IsDeleted
CreateDate
ModifyDate


SELECT TOP(100) *
	  FROM [dbo].[Events] WITH (NOLOCK)
	  WHERE CreateDate BETWEEN '2023-04-07 20:00:00' AND '2023-04-07 21:00:00' 
	  AND EventType = 'Approval'
	  AND  JSON_VALUE(EventObject, '$.Items[0].Nested.Code') IS NULL




Id
OrderId
EventGuid
EventType
EventSource
TransactionTime
EventObject
IsDeleted
CreateDate
ModifyDate


SELECT TOP(100) *
	  FROM [dbo].[Events] WITH (NOLOCK)
	  WHERE CreateDate BETWEEN '2023-04-07 21:00:00' AND '2023-04-07 22:00:00' 
	  AND EventType = 'Approval'
	  AND  JSON_VALUE(EventObject, '$.Items[0].Nested.Code') IS NULL




Id
OrderId
EventGuid
EventType
EventSource
TransactionTime
EventObject
IsDeleted
CreateDate
ModifyDate


SELECT TOP(100) *
	  FROM [dbo].[Events] WITH (NOLOCK)
	  WHERE CreateDate BETWEEN '2023-04-07 22:00:00' AND '2023-04-07 23:00:00' 
	  AND EventType = 'Approval'
	  AND  JSON_VALUE(EventObject, '$.Items[0].Nested.Code') IS NULL




Id
OrderId
EventGuid
EventType
EventSource
TransactionTime
EventObject
IsDeleted
CreateDate
ModifyDate


SELECT TOP(100) *
	  FROM [dbo].[Events] WITH (NOLOCK)
	  WHERE CreateDate BETWEEN '2023-04-07 23:00:00' AND '2023-04-08 00:00:00' 
	  AND EventType = 'Approval'
	  AND  JSON_VALUE(EventObject, '$.Items[0].Nested.Code') IS NULL




Id
OrderId
EventGuid
EventType
EventSource
TransactionTime
EventObject
IsDeleted
CreateDate
ModifyDate


SELECT TOP(100) *
	  FROM [dbo].[Events] WITH (NOLOCK)
	  WHERE CreateDate BETWEEN '2023-04-08 00:00:00' AND '2023-04-08 01:00:00' 
	  AND EventType = 'Approval'
	  AND  JSON_VALUE(EventObject, '$.Items[0].Nested.Code') IS NULL




Id
OrderId
EventGuid
EventType
EventSource
TransactionTime
EventObject
IsDeleted
CreateDate
ModifyDate


SELECT TOP(100) *
	  FROM [dbo].[Events] WITH (NOLOCK)
	  WHERE CreateDate BETWEEN '2023-04-08 01:00:00' AND '2023-04-08 02:00:00' 
	  AND EventType = 'Approval'
	  AND  JSON_VALUE(EventObject, '$.Items[0].Nested.Code') IS NULL




Id
OrderId
EventGuid
EventType
EventSource
TransactionTime
EventObject
IsDeleted
CreateDate
ModifyDate


SELECT TOP(100) *
	  FROM [dbo].[Events] WITH (NOLOCK)
	  WHERE CreateDate BETWEEN '2023-04-08 02:00:00' AND '2023-04-08 03:00:00' 
	  AND EventType = 'Approval'
	  AND  JSON_VALUE(EventObject, '$.Items[0].Nested.Code') IS NULL




Id
OrderId
EventGuid
EventType
EventSource
TransactionTime
EventObject
IsDeleted
CreateDate
ModifyDate


SELECT TOP(100) *
	  FROM [dbo].[Events] WITH (NOLOCK)
	  WHERE CreateDate BETWEEN '2023-04-08 03:00:00' AND '2023-04-08 04:00:00' 
	  AND EventType = 'Approval'
	  AND  JSON_VALUE(EventObject, '$.Items[0].Nested.Code') IS NULL




Id
OrderId
EventGuid
EventType
EventSource
TransactionTime
EventObject
IsDeleted
CreateDate
ModifyDate


SELECT TOP(100) *
	  FROM [dbo].[Events] WITH (NOLOCK)
	  WHERE CreateDate BETWEEN '2023-04-08 04:00:00' AND '2023-04-08 05:00:00' 
	  AND EventType = 'Approval'
	  AND  JSON_VALUE(EventObject, '$.Items[0].Nested.Code') IS NULL




Id
OrderId
EventGuid
EventType
EventSource
TransactionTime
EventObject
IsDeleted
CreateDate
ModifyDate


SELECT TOP(100) *
	  FROM [dbo].[Events] WITH (NOLOCK)
	  WHERE CreateDate BETWEEN '2023-04-08 05:00:00' AND '2023-04-08 06:00:00' 
	  AND EventType = 'Approval'
	  AND  JSON_VALUE(EventObject, '$.Items[0].Nested.Code') IS NULL




Id
OrderId
EventGuid
EventType
EventSource
TransactionTime
EventObject
IsDeleted
CreateDate
ModifyDate


SELECT TOP(100) *
	  FROM [dbo].[Events] WITH (NOLOCK)
	  WHERE CreateDate BETWEEN '2023-04-08 06:00:00' AND '2023-04-08 07:00:00' 
	  AND EventType = 'Approval'
	  AND  JSON_VALUE(EventObject, '$.Items[0].Nested.Code') IS NULL




Id
OrderId
EventGuid
EventType
EventSource
TransactionTime
EventObject
IsDeleted
CreateDate
ModifyDate


SELECT TOP(100) *
	  FROM [dbo].[Events] WITH (NOLOCK)
	  WHERE CreateDate BETWEEN '2023-04-08 07:00:00' AND '2023-04-08 08:00:00' 
	  AND EventType = 'Approval'
	  AND  JSON_VALUE(EventObject, '$.Items[0].Nested.Code') IS NULL




Id
OrderId
EventGuid
EventType
EventSource
TransactionTime
EventObject
IsDeleted
CreateDate
ModifyDate


SELECT TOP(100) *
	  FROM [dbo].[Events] WITH (NOLOCK)
	  WHERE CreateDate BETWEEN '2023-04-08 08:00:00' AND '2023-04-08 09:00:00' 
	  AND EventType = 'Approval'
	  AND  JSON_VALUE(EventObject, '$.Items[0].Nested.Code') IS NULL




Id
OrderId
EventGuid
EventType
EventSource
TransactionTime
EventObject
IsDeleted
CreateDate
ModifyDate


SELECT TOP(100) *
	  FROM [dbo].[Events] WITH (NOLOCK)
	  WHERE CreateDate BETWEEN '2023-04-08 09:00:00' AND '2023-04-08 10:00:00' 
	  AND EventType = 'Approval'
	  AND  JSON_VALUE(EventObject, '$.Items[0].Nested.Code') IS NULL




Id
OrderId
EventGuid
EventType
EventSource
TransactionTime
EventObject
IsDeleted
CreateDate
ModifyDate


SELECT TOP(100) *
	  FROM [dbo].[Events] WITH (NOLOCK)
	  WHERE CreateDate BETWEEN '2023-04-08 10:00:00' AND '2023-04-08 11:00:00' 
	  AND EventType = 'Approval'
	  AND  JSON_VALUE(EventObject, '$.Items[0].Nested.Code') IS NULL




Id
OrderId
EventGuid
EventType
EventSource
TransactionTime
EventObject
IsDeleted
CreateDate
ModifyDate


SELECT TOP(100) *
	  FROM [dbo].[Events] WITH (NOLOCK)
	  WHERE CreateDate BETWEEN '2023-04-08 11:00:00' AND '2023-04-08 12:00:00' 
	  AND EventType = 'Approval'
	  AND  JSON_VALUE(EventObject, '$.Items[0].Nested.Code') IS NULL




Id
OrderId
EventGuid
EventType
EventSource
TransactionTime
EventObject
IsDeleted
CreateDate
ModifyDate


SELECT TOP(100) *
	  FROM [dbo].[Events] WITH (NOLOCK)
	  WHERE CreateDate BETWEEN '2023-04-08 12:00:00' AND '2023-04-08 13:00:00' 
	  AND EventType = 'Approval'
	  AND  JSON_VALUE(EventObject, '$.Items[0].Nested.Code') IS NULL




Id
OrderId
EventGuid
EventType
EventSource
TransactionTime
EventObject
IsDeleted
CreateDate
ModifyDate


SELECT TOP(100) *
	  FROM [dbo].[Events] WITH (NOLOCK)
	  WHERE CreateDate BETWEEN '2023-04-08 13:00:00' AND '2023-04-08 14:00:00' 
	  AND EventType = 'Approval'
	  AND  JSON_VALUE(EventObject, '$.Items[0].Nested.Code') IS NULL




Id
OrderId
EventGuid
EventType
EventSource
TransactionTime
EventObject
IsDeleted
CreateDate
ModifyDate


SELECT TOP(100) *
	  FROM [dbo].[Events] WITH (NOLOCK)
	  WHERE CreateDate BETWEEN '2023-04-08 14:00:00' AND '2023-04-08 15:00:00' 
	  AND EventType = 'Approval'
	  AND  JSON_VALUE(EventObject, '$.Items[0].Nested.Code') IS NULL




Id
OrderId
EventGuid
EventType
EventSource
TransactionTime
EventObject
IsDeleted
CreateDate
ModifyDate


SELECT TOP(100) *
	  FROM [dbo].[Events] WITH (NOLOCK)
	  WHERE CreateDate BETWEEN '2023-04-08 15:00:00' AND '2023-04-08 16:00:00' 
	  AND EventType = 'Approval'
	  AND  JSON_VALUE(EventObject, '$.Items[0].Nested.Code') IS NULL




Id
OrderId
EventGuid
EventType
EventSource
TransactionTime
EventObject
IsDeleted
CreateDate
ModifyDate


SELECT TOP(100) *
	  FROM [dbo].[Events] WITH (NOLOCK)
	  WHERE CreateDate BETWEEN '2023-04-08 16:00:00' AND '2023-04-08 17:00:00' 
	  AND EventType = 'Approval'
	  AND  JSON_VALUE(EventObject, '$.Items[0].Nested.Code') IS NULL




Id
OrderId
EventGuid
EventType
EventSource
TransactionTime
EventObject
IsDeleted
CreateDate
ModifyDate


SELECT TOP(100) *
	  FROM [dbo].[Events] WITH (NOLOCK)
	  WHERE CreateDate BETWEEN '2023-04-08 17:00:00' AND '2023-04-08 18:00:00' 
	  AND EventType = 'Approval'
	  AND  JSON_VALUE(EventObject, '$.Items[0].Nested.Code') IS NULL




Id
OrderId
EventGuid
EventType
EventSource
TransactionTime
EventObject
IsDeleted
CreateDate
ModifyDate


SELECT TOP(100) *
	  FROM [dbo].[Events] WITH (NOLOCK)
	  WHERE CreateDate BETWEEN '2023-04-08 18:00:00' AND '2023-04-08 19:00:00' 
	  AND EventType = 'Approval'
	  AND  JSON_VALUE(EventObject, '$.Items[0].Nested.Code') IS NULL




Id
OrderId
EventGuid
EventType
EventSource
TransactionTime
EventObject
IsDeleted
CreateDate
ModifyDate


SELECT TOP(100) *
	  FROM [dbo].[Events] WITH (NOLOCK)
	  WHERE CreateDate BETWEEN '2023-04-08 19:00:00' AND '2023-04-08 20:00:00' 
	  AND EventType = 'Approval'
	  AND  JSON_VALUE(EventObject, '$.Items[0].Nested.Code') IS NULL




Id
OrderId
EventGuid
EventType
EventSource
TransactionTime
EventObject
IsDeleted
CreateDate
ModifyDate


SELECT TOP(100) *
	  FROM [dbo].[Events] WITH (NOLOCK)
	  WHERE CreateDate BETWEEN '2023-04-08 20:00:00' AND '2023-04-08 21:00:00' 
	  AND EventType = 'Approval'
	  AND  JSON_VALUE(EventObject, '$.Items[0].Nested.Code') IS NULL




Id
OrderId
EventGuid
EventType
EventSource
TransactionTime
EventObject
IsDeleted
CreateDate
ModifyDate


SELECT TOP(100) *
	  FROM [dbo].[Events] WITH (NOLOCK)
	  WHERE CreateDate BETWEEN '2023-04-08 21:00:00' AND '2023-04-08 22:00:00' 
	  AND EventType = 'Approval'
	  AND  JSON_VALUE(EventObject, '$.Items[0].Nested.Code') IS NULL




Id
OrderId
EventGuid
EventType
EventSource
TransactionTime
EventObject
IsDeleted
CreateDate
ModifyDate


SELECT TOP(100) *
	  FROM [dbo].[Events] WITH (NOLOCK)
	  WHERE CreateDate BETWEEN '2023-04-08 22:00:00' AND '2023-04-08 23:00:00' 
	  AND EventType = 'Approval'
	  AND  JSON_VALUE(EventObject, '$.Items[0].Nested.Code') IS NULL




Id
OrderId
EventGuid
EventType
EventSource
TransactionTime
EventObject
IsDeleted
CreateDate
ModifyDate


SELECT TOP(100) *
	  FROM [dbo].[Events] WITH (NOLOCK)
	  WHERE CreateDate BETWEEN '2023-04-08 23:00:00' AND '2023-04-09 00:00:00' 
	  AND EventType = 'Approval'
	  AND  JSON_VALUE(EventObject, '$.Items[0].Nested.Code') IS NULL