Table Structure

  • Hi,

    Below are the 2 table structure from which I have to select TransactionID from table GV_Voucher which are not present in GV_ReceivedOffice. But as TransactionID column not present in Gv_ReceivedOffice so I am confused is it good to add to a TransactionId in GV_Received table or should I exctract TransactionID on basis of vouchers?

    CREATE TABLE [dbo].[GV_Voucher](

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

    [VoucherTypeId] [int] NOT NULL,

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

    [Denomination] [int] NOT NULL,

    [ExpiryDate] [datetime] NULL,

    [CreatedDate] [datetime] NULL,

    [ModifyDate] [datetime] NULL,

    [VoucherStatusId] [int] NOT NULL,

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

    [Quantity] [int] NOT NULL,

    [AmountValue] [int] NULL,

    [CreatedBy] [nvarchar](50) NULL,

    [ModifiedBy] [nvarchar](50) NULL,

    [Validatedays] [int] NULL,

    [IsDeleted] [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],

    CONSTRAINT [UN_GVVoucher_VoucherNo] UNIQUE NONCLUSTERED

    (

    [VoucherNo] ASC

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

    ) ON [PRIMARY]

    GO

    SET ANSI_PADDING OFF

    GO

    ALTER TABLE [dbo].[GV_Voucher] WITH NOCHECK ADD CONSTRAINT [FK_GV_Voucher_GV_VoucherStatus] FOREIGN KEY([VoucherStatusId])

    REFERENCES [dbo].[GV_VoucherStatus] ([VoucherStatusId])

    GO

    ALTER TABLE [dbo].[GV_Voucher] NOCHECK CONSTRAINT [FK_GV_Voucher_GV_VoucherStatus]

    GO

    ALTER TABLE [dbo].[GV_Voucher] WITH NOCHECK ADD CONSTRAINT [FK_GV_Voucher_GV_VoucherType] FOREIGN KEY([VoucherTypeId])

    REFERENCES [dbo].[GV_VoucherType] ([VoucherTypeID])

    GO

    ALTER TABLE [dbo].[GV_Voucher] NOCHECK CONSTRAINT [FK_GV_Voucher_GV_VoucherType]

    GO

    -----------------------------------------------------------------------------------------

    CREATE TABLE [dbo].[GV_ReceivedOffice](

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

    [VoucherNo] [varchar](20) NULL,

    [ReceivedDate] [datetime] NULL,

    [ReceivedBy] [int] NULL,

    PRIMARY KEY CLUSTERED

    (

    [ReceivedOfficeID] ASC

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

    ) ON [PRIMARY]

    GO

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

  • Is it possible for TransactionID to be duplicated in the table GV_Voucher?

    If the answer is No, then you can fetch it based on VoucherNo's else you will need TransactionID in both the tables.


    Kingston Dhasian

    How to post data/code on a forum to get the best help - Jeff Moden
    http://www.sqlservercentral.com/articles/Best+Practices/61537/

  • It depends on TransactionID as Kingston said.

    How big are the tables? Do they have many indexes?

    Regards

    IgorMi

    Igor Micev,My blog: www.igormicev.com

  • Kingston Dhasian (4/26/2013)


    Is it possible for TransactionID to be duplicated in the table GV_Voucher?

    If the answer is No, then you can fetch it based on VoucherNo's else you will need TransactionID in both the tables.

    ye sTransactionID is duplicate in table Gv_voucher and voucherno is unique

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

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply