/*
	Let us create the sample table and populate it.
*/

CREATE TABLE [dbo].[OrderDetails](
	[OrderDetailID] [int] IDENTITY(1,1) NOT NULL,
	[OrderNumber] VARCHAR(10) NOT NULL,
	[ItemNumber] [varchar](20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
	[Qty] [int] NULL,
	[Rate] FLOAT NULL,
	[QtyPicked] INT NULL
) ON [PRIMARY]

INSERT INTO OrderDetails (OrderNumber, ItemNumber, Qty, Rate, QtyPicked)
	SELECT '00001', 'A001', 10, 11.25, 0
	UNION SELECT '00001', 'A002', 20, 15, 0
	UNION SELECT '00001', 'A003', 30, 23.75, 0