Hi All,
I have a table time column(EMP_ADJ_SIGN_ON_TIME), I want to insert these time value PROD_UNTS into another table with time buckets like 7 to 8 and 8 to 9 columns.
CREATE TABLE [dbo].[EMPTIME](
[CDATE] [datetime] NOT NULL,
[PRDSTLE] [char](14) NULL,
[EMP_ADJ_SIGN_ON_TIME] [decimal](4, 2) NULL,
[PROD_UNTS] [int] NULL
)
GO
INSERT [dbo].[EMPTIME] ([CDATE], [PRDSTLE], [EMP_ADJ_SIGN_ON_TIME], [PROD_UNTS]) VALUES (CAST(N'2021-07-11 07:18:10.090' AS DateTime), N'ABC', CAST(7.18 AS Decimal(4, 2)), 14)
GO
INSERT [dbo].[EMPTIME] ([CDATE], [PRDSTLE], [EMP_ADJ_SIGN_ON_TIME], [PROD_UNTS]) VALUES (CAST(N'2021-07-11 07:56:10.090' AS DateTime), N'ABC', CAST(7.63 AS Decimal(4, 2)), 10)
GO
INSERT [dbo].[EMPTIME] ([CDATE], [PRDSTLE], [EMP_ADJ_SIGN_ON_TIME], [PROD_UNTS]) VALUES (CAST(N'2021-07-11 09:30:10.090' AS DateTime), N'SANTOOR', CAST(9.64 AS Decimal(4, 2)), 331)
GO
INSERT [dbo].[EMPTIME] ([CDATE], [PRDSTLE], [EMP_ADJ_SIGN_ON_TIME], [PROD_UNTS]) VALUES (CAST(N'2021-07-11 09:30:10.090' AS DateTime), N'SANTOOR', CAST(9.00 AS Decimal(4, 2)), 0)
GO
INSERT [dbo].[EMPTIME] ([CDATE], [PRDSTLE], [EMP_ADJ_SIGN_ON_TIME], [PROD_UNTS]) VALUES (CAST(N'2021-07-11 12:43:10.090' AS DateTime), N'CINTHOL ', CAST(12.43 AS Decimal(4, 2)), 0)
GO
INSERT [dbo].[EMPTIME] ([CDATE], [PRDSTLE], [EMP_ADJ_SIGN_ON_TIME], [PROD_UNTS]) VALUES (CAST(N'2021-07-11 11:22:10.090' AS DateTime), N'ABC ', CAST(11.22 AS Decimal(4, 2)), 215)
GO
Thanks in Advance.

