Bulk

 

📄 FILE 1 — PLO_Bulk.sql (ALL NVARCHAR)

DECLARE @StartBase NVARCHAR(20) = '112211';

DECLARE @TotalOrders INT = 10;   -- loop counter only

DECLARE @i INT = 0;

DECLARE @OrderDate NVARCHAR(50) = '2025-08-21T06:08:00Z';

WHILE @i < @TotalOrders

BEGIN

    DECLARE @ORDERID NVARCHAR(20) =

        CONVERT(NVARCHAR(20), CONVERT(INT, @StartBase) + @i);

    DECLARE @VistaOrderNo NVARCHAR(20) = '17' + @ORDERID;

    DECLARE @Message NVARCHAR(MAX);

    SET @Message =

        '<CreationDateTime>' + @OrderDate + '</CreationDateTime>' +

        '<ID>' + @ORDERID + '</ID>' +

        '<ValueString>' + @VistaOrderNo + '</ValueString>';

    INSERT INTO dbo.JLR_ProductionScheduleDown

        (Event_Message, Event_InsertDate, Event_ErrorCode)

    VALUES

        (@Message, GETUTCDATE(), 0);

    SET @i = @i + 1;

END;

📄 FILE 2 — BOM_Bulk.sql (ALL NVARCHAR)

DECLARE @StartBase NVARCHAR(20) = '112211';

DECLARE @TotalOrders INT = 10;

DECLARE @i INT = 0;

DECLARE @OrderDate NVARCHAR(50) = '2025-08-21T06:08:00Z';

WHILE @i < @TotalOrders

BEGIN

    DECLARE @ORDERID NVARCHAR(20) =

        CONVERT(NVARCHAR(20), CONVERT(INT, @StartBase) + @i);

    DECLARE @Message NVARCHAR(MAX);

    SET @Message =

        '<CreationDateTime>' + @OrderDate + '</CreationDateTime>' +

        '<ID>' + @ORDERID + '</ID>';

    INSERT INTO dbo.JLR_OrderBOMMDGDown

        (Event_Message, Event_InsertDate, Event_ErrorCode)

    VALUES

        (@Message, GETUTCDATE(), 0);

    SET @i = @i + 1;

END;

📄 FILE 3 — Plan24_Bulk.sql (ALL NVARCHAR)

DECLARE @StartBase NVARCHAR(20) = '112211';

DECLARE @TotalOrders INT = 10;

DECLARE @i INT = 0;

DECLARE @OrderDate NVARCHAR(50) = '2025-08-21T06:08:00Z';

WHILE @i < @TotalOrders

BEGIN

    DECLARE @ORDERID NVARCHAR(20) =

        CONVERT(NVARCHAR(20), CONVERT(INT, @StartBase) + @i);

    DECLARE @BSN NVARCHAR(20) = @ORDERID;

    DECLARE @Message NVARCHAR(MAX);

    SET @Message =

        '<CreationDateTime>' + @OrderDate + '</CreationDateTime>' +

        '<ID>' + @ORDERID + '</ID>' +

        '<ValueString>' + @BSN + '</ValueString>';

    INSERT INTO dbo.JLR_OrderTriggerDown

        (Event_Message, Event_InsertDate, Event_ErrorCode)

    VALUES

        (@Message, GETUTCDATE(), 0);

    SET @i = @i + 1;

END;

📄 FILE 4 — TLS_Bulk.sql (ALL NVARCHAR)

DECLARE @StartBase NVARCHAR(20) = '112211';

DECLARE @TotalOrders INT = 10;

DECLARE @i INT = 0;

DECLARE @OrderDate NVARCHAR(50) = '2025-08-21T06:08:00Z';

DECLARE @BodyShop NVARCHAR(50) = 'BS03';

WHILE @i < @TotalOrders

BEGIN

    DECLARE @ORDERID NVARCHAR(20) =

        CONVERT(NVARCHAR(20), CONVERT(INT, @StartBase) + @i);

    DECLARE @BSN NVARCHAR(20) = @ORDERID;

    DECLARE @TLS NVARCHAR(20) = RIGHT('00000000' + @ORDERID, 8);

    DECLARE @CARIN NVARCHAR(20) = '1' + @ORDERID;

    DECLARE @Message NVARCHAR(MAX);

    SET @Message =

        '<CreationDateTime>' + @OrderDate + '</CreationDateTime>' +

        '<ID>' + @ORDERID + '</ID>' +

        '<ValueString>' + @BodyShop + '</ValueString>' +

        '<ValueString>' + @TLS + '</ValueString>' +

        '<ValueString>' + @BSN + '</ValueString>' +

        '<ValueString>' + @CARIN + '</ValueString>';

    INSERT INTO dbo.JLR_MCISDown

        (Event_Message, Event_InsertDate, Event_ErrorCode)

    VALUES

        (@Message, GETUTCDATE(), 0);

    SET @i = @i + 1;

END;

📄 FILE 5 — VIN_Bulk.sql (ALL NVARCHAR)

DECLARE @StartBase NVARCHAR(20) = '112211';

DECLARE @TotalOrders INT = 10;

DECLARE @i INT = 0;

DECLARE @OrderDate NVARCHAR(50) = '2025-08-21T06:08:00Z';

DECLARE @BodyShop NVARCHAR(50) = 'BS03';

WHILE @i < @TotalOrders

BEGIN

    DECLARE @ORDERID NVARCHAR(20) =

        CONVERT(NVARCHAR(20), CONVERT(INT, @StartBase) + @i);

    DECLARE @BSN NVARCHAR(20) = @ORDERID;

    DECLARE @TLS NVARCHAR(20) = RIGHT('00000000' + @ORDERID, 8);

    DECLARE @CARIN NVARCHAR(20) = '1' + @ORDERID;

    DECLARE @VIN NVARCHAR(50) = 'SALYA2AY5SA' + @ORDERID;

    DECLARE @Message NVARCHAR(MAX);

    SET @Message =

        '<CreationDateTime>' + @OrderDate + '</CreationDateTime>' +

        '<ID>' + @ORDERID + '</ID>' +

        '<ValueString>' + @BodyShop + '</ValueString>' +

        '<ValueString>' + @TLS + '</ValueString>' +

        '<ValueString>' + @BSN + '</ValueString>' +

        '<ValueString>' + @VIN + '</ValueString>' +

        '<ValueString>' + @CARIN + '</ValueString>';

    INSERT INTO dbo.JLR_MCISDown

        (Event_Message, Event_InsertDate, Event_ErrorCode)

    VALUES

        (@Message, GETUTCDATE(), 0);

    SET @i = @i + 1;

END;