• This should be enough:

    ---------------------[dbo].[Transaction]-----------------

    ALTER TABLE [dbo].[Transaction] ADD CONSTRAINT [PK_Transaction] PRIMARY KEY CLUSTERED

    (

    [TransactionDate] ASC,

    [ReferenceNumber] ASC

    )

    The rest of the parameters, as I can understand, are optional, and adding them to the index may just cause choosing not optimal plans for different parameter combinations.

    _____________
    Code for TallyGenerator