insert into #temp 
	(runnumber, stockid, minimumBid, TitleType, ActualCashValue, Vehcile, NonVehicle, AssignorID, Company) 
values 
SELECT
    StockSale.RunNumber, Stock.StockID, Stock.MinimumBid, isnull(Title.NewTitleTypeCode, Title.OrigTitleTypeCode) as 'Title Type', Stock.ActualCashValue
    (Cast(Vehicle.[Year] as char(4))+ ' ' + Vehicle.Make + ' ' + Vehicle.Model) as Vehicle, (NonVehicle.BrandName + ' ' + NonVehicle.BrandModel) as nonVehicle,  
    AssignorStock.AssignorID, IsNull(Company.CompanyName, CompanySeller.CompanyName) as Company
FROM
         AIMS.dbo.Sale Sale 
     INNER JOIN AIMS.dbo.StockSale StockSale ON
        Sale.SaleID = StockSale.SaleID
     INNER JOIN AIMS.dbo.Stock Stock ON
        StockSale.StockID = Stock.StockID
     LEFT OUTER JOIN AIMS.dbo.NonVehicle NonVehicle ON
        Stock.StockID = NonVehicle.StockID
     INNER JOIN AIMS.dbo.AssignorStock AssignorStock ON
        Stock.AssignmentID = AssignorStock.AssignmentID
     LEFT OUTER JOIN AIMS.dbo.Charge Charge ON
        Stock.StockID = Charge.StockID
     LEFT OUTER JOIN AIMS.dbo.Vehicle Vehicle ON
        Stock.StockID = Vehicle.StockID
     LEFT OUTER JOIN AIMS.dbo.Assignor Assignor ON
        AssignorStock.AssignorID = Assignor.AssignorID
     LEFT OUTER JOIN AIMS.dbo.Seller Seller ON
        AssignorStock.SellerID = Seller.SellerID
     LEFT OUTER JOIN AIMS.dbo.RFChargeType RFChargeType ON
        Charge.ChargeTypeCode = RFChargeType.ChargeTypeCode
     LEFT OUTER JOIN AIMS.dbo.Title Title ON
        Vehicle.VehicleID = Title.VehicleID
     LEFT OUTER JOIN AIMS.dbo.Company CompanySeller ON
        Seller.CompanyID = CompanySeller.CompanyID
     LEFT OUTER JOIN AIMS.dbo.Company Company ON
        Assignor.CompanyID = Company.CompanyID
WHERE  
	Sale.SaleID = @saleID
and 
	StockSale.stockID=@stockID

quote:

---

Originally posted by tduggan

Get rid of values. You can't use a SELECT if you specify values.

INSERT INTO Table1 (ColumnList...)
SELECT ColumnList
FROM

OR

INSERT INTO Table1 ()
VALUES ()

Tara

---