• This is the table structure if anyone requires:

    REATE TABLE [dbo].[GV_Voucher](

    [VoucherId] [int] IDENTITY(1,1) NOT NULL,

    [VoucherTypeId] [int] NOT NULL,

    [VoucherNo] [varchar](20) NOT NULL,

    [Denomination] [int] NOT NULL,

    [BookletId] [int] NULL,

    [ExpiryDate] [date] NULL,

    [CreatedDate] [datetime] NULL,

    [ModifyDate] [datetime] NULL,

    [UserId] [uniqueidentifier] NULL,

    [VoucherStatusId] [int] NOT NULL,

    [TransactionID] [varchar](20) NOT NULL,

    [Quantity] [int] NOT NULL,

    [IsBooklet] [bit] NULL,

    CONSTRAINT [PK_GV_Voucher] PRIMARY KEY CLUSTERED

    (

    [VoucherId] ASC

    )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]

    ) ON [PRIMARY]

    _______________________________________________________________
    To get quick answer follow this link:
    http://www.sqlservercentral.com/articles/Best+Practices/61537/