Problem With insert Query With Where Conditions

Question

Am Using Query Like this

insert into BalanceSheet (Balance) select @Balance FROM OrderBill WHERE CustomerID=@CustomerID and InvoiceID=@InvoiceID

Getting Error Like

Cannot insert the value NULL into column 'CustID', table 'BillingAndAccounts.dbo.BalanceSheet'; column does not allow nulls. INSERT fails.

The statement has been terminated.

Jignesh Trivedi · Answer

Hi I think you are doing something wrong with requirement. you are inserting only Balance data into BalanceSheet table what about other reference data like customer id transaction type (credit/ debit) etc... agree with above two answer

Khan Abrar Ahmed · Answer

Hi you have to make CustID as nullable column or add in the column in insert statement to insert the CustID.

Shehzad · Answer

insert into BalanceSheet ( CustID Balance) select CustomerID @Balance FROM OrderBill WHERE CustomerID=@CustomerID and InvoiceID=@InvoiceID This should work