Link to home
Start Free TrialLog in
Avatar of mdward4
mdward4

asked on

Select NULL into table

I have a table with 2 columns that allow NULL.  I am attempting to create a SP that will populate this table.  It is as follows:

INSERT INTO TitleApproval

SELECT     GETDATE() AS FaxDate, Stock.StockID

FROM         Stock INNER JOIN
                      AssignorStock ON Stock.AssignmentID = AssignorStock.AssignmentID INNER JOIN
                      Assignor ON AssignorStock.AssignorID = Assignor.AssignorID INNER JOIN
                      RFStockStatus ON Stock.StockStatusInd = RFStockStatus.StockStatusID
WHERE     (Assignor.ParentCompanyID = 7812) AND (Stock.StockStatusInd = 64)
GROUP BY Stock.StockID
HAVING      (NOT (Stock.StockID IN
                          (SELECT     TitleApproval.StockID
                            FROM          Stock AS Stock_1 INNER JOIN
                                                   TitleApproval ON Stock_1.StockID = TitleApproval.StockID
                            WHERE      (Stock_1.StockStatusInd = 64) AND (TitleApproval.Approve IS NULL) OR
                                                   (Stock_1.StockStatusInd = 64) AND (TitleApproval.Approve = '1'))))

Yet, when I attempt to create the SP, I get this error "Insert Error: Column name or number of supplied values does not match table definition."  I need to insert NULL values into these columns, but I am brain dead today and cannot figure out how to.
ASKER CERTIFIED SOLUTION
Avatar of Aneesh
Aneesh
Flag of Canada image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of mdward4
mdward4

ASKER

I had tried option 2 already with no success, but option 1 worked.  Thanks.