if we add the value PaymentId  for example(1,2,3) then all paymentId related fields we add the 1,2,3 value but when we add these value then they gave me a error?

hi

Any one help mee ????

hi

 here it is Create Procedure

CREATE TABLE [PaymentTypes] (

            [referenceNo] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,

            [payCode] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,

 Hi,

when we add the value for Cheque Payment in Query analyzer then they gave me a these ERROR.

(1 row(s) affected)

(1 row(s) affected)

Server: Msg 547, Level 16, State 1, Procedure SP_InsertNewInvoice, Line...

Hi,

when we add the value for Cheque Payment then they gave me a There ERROR.

(1 row(s) affected)

(1 row(s) affected)

Server: Msg 547, Level 16, State 1, Procedure SP_InsertNewInvoice, Line 45

INSERT statement conflicted...

when we complete the restore procedure then HOW to See this Backup file which we store already??

Hi Greq Charles,

how to define Composite key in Enterprise manager?

we set the primery key but confusion in Declaring the Composite key ?

thanks

this work you tell me how to do  in Enterprise manager in sql server 2000

NonStockable Item have two categorys such as

1) Category Connection is fixPrice

2) Category Services is Variable Price

FixPrice : (connectionCharges,packagePlan,SIMCustomDuty)

VariablePrice: (CEDonLineRent,repairCharges,rentalCharges,SIMreplacementCharges,

depreciationCharges)

NonStockable Item have two categorys such as

1) Category Connection is fixPrice

2) Category Services is Variable Price

FixPrice : (connectionCharges,packagePlan,SIMCustomDuty)

VariablePrice: (CEDonLineRent,repairCharges,rentalCharges,SIMreplacementCharges,

depreciationCharges)

yes my clas inheritance hierarchy is

Items

         Stockable

          Nonstockable

          NondtockableTypes

          FixedPrice

          variableprice

chargeableItems are of two types

1)  Stockable

2)  NonStockable

StockableItem : (stockableId,cards,hardware)

NonstockableItem: (itemCode,connection,services,promotion)

futherMore Nonstockable items are of two types:

FixedPrice:  where price of...

Actually we use a creditCardName for which type of creditCard used the customer .

Its my mistake ,yes we store the CreditCardNo for storing the Data.

Yes we have a customer Table.