Grouping Issue

Please find the DML statement below:

SET IDENTITY_INSERT [dbo].[BHDDeliveryDet] ON;

BEGIN TRANSACTION;

INSERT INTO [dbo].[BHDDeliveryDet]([BHDDeliveryDetailid], [BHDDeliveryNo], [Currencyid], [Denomination], [Quantity])

SELECT 57, 19, 98, 20.000, 1000 UNION ALL

SELECT 58, 19, 98, 10.000, 1000 UNION ALL

SELECT 59, 19, 98, 0.500, 1000 UNION ALL

SELECT 60, 20, 98, 20.000, 1000 UNION ALL

SELECT 61, 20, 98, 10.000, 1000 UNION ALL

SELECT 62, 20, 98, 20.000, 1000 UNION ALL

SELECT 63, 20, 98, 20.000, 1200 UNION ALL

SELECT 64, 21, 98, 20.000, 1200 UNION ALL

SELECT 65, 21, 98, 20.000, 1200 UNION ALL

SELECT 66, 21, 98, 20.000, 1600 UNION ALL

SELECT 67, 21, 98, 20.000, 1800

COMMIT;

RAISERROR (N'[dbo].[BHDDeliveryDet]: Insert Batch: 1.....Done!', 10, 1) WITH NOWAIT;

GO

SET IDENTITY_INSERT [dbo].[BHDDeliveryDet] OFF;

SET IDENTITY_INSERT [dbo].[Currency] ON;

BEGIN TRANSACTION;

INSERT INTO [dbo].[Currency]([Currencyid], [CurrencyISOCode], [CurrencyCountry], [Currency])

SELECT 97, N'SAR', N'Saudia', N'Saudi Riyals' UNION ALL

SELECT 98, N'BHD', N'Bahrain', N'Dinar' UNION ALL

SELECT 100, N'INR', N'Indonesia', N'Dirham' UNION ALL

SELECT 101, N'MUR', N'Malaysia', N'Dong'

COMMIT;

RAISERROR (N'[dbo].[Currency]: Insert Batch: 1.....Done!', 10, 1) WITH NOWAIT;

GO

SET IDENTITY_INSERT [dbo].[Currency] OFF;

SET IDENTITY_INSERT [dbo].[CurrencyDetails] ON;

BEGIN TRANSACTION;

INSERT INTO [dbo].[CurrencyDetails]([CurDenid], [Currencyid], [Denomination], [DenominationType])

SELECT 479, 97, 1000.000, N'Currency' UNION ALL

SELECT 480, 97, 500.000, N'Coin' UNION ALL

SELECT 481, 98, 20.000, N'Currency' UNION ALL

SELECT 482, 98, 10.000, N'Currency' UNION ALL

SELECT 483, 98, 5.000, N'Currency' UNION ALL

SELECT 484, 98, 1.000, N'Currency' UNION ALL

SELECT 485, 98, 0.500, N'Currency' UNION ALL

SELECT 486, 98, 0.100, N'Coin' UNION ALL

SELECT 487, 98, 0.050, N'Coin' UNION ALL

SELECT 488, 98, 0.025, N'Coin' UNION ALL

SELECT 489, 98, 0.010, N'Coin' UNION ALL

SELECT 494, 100, 500.000, N'Currency'

COMMIT;

RAISERROR (N'[dbo].[CurrencyDetails]: Insert Batch: 1.....Done!', 10, 1) WITH NOWAIT;

GO

SET IDENTITY_INSERT [dbo].[CurrencyDetails] OFF;