CODE:N1043376
Error:16_4104_1_-2146232060
SQL:
SELECT  vtb.OrderSourceSKUID
FROM    RB_Amazon_Product_Base vtb ( NOLOCK )
        LEFT JOIN RB_StockClearDetailed scd ( NOLOCK ) ON ( vtb.OrderSourceSKUID = scd.ListId
                                                            AND vtb.CustomerID = scd.CustomerID AND vtb.IsDelete=0
                                                            AND ( clearType = 1
                                                              OR clearType = 3
                                                              )
                                                          )
        LEFT JOIN ( SELECT  SUM(GoodNum) AS Inventory ,
                            WareHouseID ,
                            SKU ,
                            CustomerID
                    FROM    RB_WareHouse_Product (NOLOCK)
                    GROUP BY WareHouseID ,
                            SKU ,
                            CustomerID
                  ) AS tbWHN ON ( vtb.WID = tbWHN.WareHouseID
                                  AND vtb.SKU = tbWHN.SKU
                                  AND vtb.CustomerID = tbWHN.CustomerID
                                )
        LEFT JOIN RB_OrderSource b ON vtb.CustomerID = b.CustomerID
                                      AND vtb.OrderSourceID = b.ID
        LEFT JOIN RB_Product p ( NOLOCK ) ON p.CustomerID = vtb.CustomerID
                                             AND vtb.SKU = p.SKU
        LEFT JOIN RB_WareHouse wh ( NOLOCK ) ON wh.CustomerID = p.CustomerID
                                                AND wh.ID = p.DefaultLocalWarehouse
        LEFT JOIN RB_Product_SupplierPrice psb ( NOLOCK ) ON p.CustomerID = psb.CustomerID
                                                             AND p.SKU = psb.SKU
                                                             AND psb.IsDefault = 1
        LEFT JOIN RB_Product_Supplier c ( NOLOCK ) ON psb.CustomerID = c.CustomerID
                                                      AND psb.SupplierID = c.ID
        LEFT JOIN RB_WareHouse swh ( NOLOCK ) ON swh.CustomerID = c.CustomerID
                                                 AND swh.ID = c.TheWareHouseID
        LEFT JOIN dbo.RB_Admin ON vtb.CustomerID = dbo.RB_Admin.CustomerID
                                  AND b.SaleAdminID = dbo.RB_Admin.ID
                                  AND dbo.RB_Admin.IsActive = 1
                                  AND dbo.RB_Admin.IsLock = 0
        LEFT JOIN RB_Product_Admin pa ( NOLOCK ) ON vtb.CustomerID = pa.CustomerID
                                                    AND vtb.SKU = pa.SKU
        LEFT JOIN RB_WareHouse_Product wp ( NOLOCK ) ON wp.CustomerID = vtb.CustomerID
                                                        AND wp.ID = WPID
        LEFT JOIN RB_SalesSactorHolidays sh ( NOLOCK ) ON sh.CustomerID = vtb.CustomerID
                                                          AND sh.ID = vtb.HolidaysID
        LEFT JOIN RB_Customer_Setting setting ( NOLOCK ) ON setting.CustomerID = vtb.CustomerID
        LEFT OUTER JOIN RB_BusinessTeam BT WITH ( NOLOCK ) ON vtb.CustomerID = BT.CustomerID
                                                              AND BT.ID = RB_Admin.BusinessTeamID WHERE   vtb.CustomerID = @CustomerID AND vtb.IsDelete=0  AND vtb.CustomerID=1 AND vtb.IsDelete=0  and isnull(vtb.IsOffShelf,0) in (1,4,5,2,0)  and vtb.OrderSourceSKUID>0   AND vtb.OrderSourceID in(15826)  AND tbColdHot.ID IS NULL
PARAMS:@CustomerID = 1 ,@UserID = 6146 ,@FolderID = 0 ,
MESSAGE:The multi-part identifier "tbColdHot.ID" could not be bound.
TRACE:   在 System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
   在 System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
   在 System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
   在 System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
   在 System.Data.SqlClient.SqlDataReader.TryConsumeMetaData()
   在 System.Data.SqlClient.SqlDataReader.get_MetaData()
   在 System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted)
   在 System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParameterEncryptionRequest)
   在 System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)
   在 System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
   在 System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)
   在 System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior)
   在 System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior)
   在 System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
   在 System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
   在 System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, String srcTable)
   在 RB.DAL.DBOperator.Query(String SQLString, SqlCommand cmd, Int32 Times, SqlParameter[] cmdParms, Boolean IsWriteDB)   在 RB.DAL.DBOperator.toCommonTipException(SqlException ex, String sql, SqlParameter[] cmdParms)
   在 RB.DAL.DBOperator.Query(String SQLString, SqlCommand cmd, Int32 Times, SqlParameter[] cmdParms, Boolean IsWriteDB)
   在 RB.DALExtend.RB_Amazon_Product_BaseExtend.GetConditionIdList(Int32 customerId, String sql, Int32 folderID, Int32 adminID)
   在 PandaBuy.ERP.Web.ASHX.IrobotBox.BeiKuCommon.SetSaleCondition(Int32 sid, String sname, String sql, Int32 folderID, Int32 adminID)
   在 PandaBuy.ERP.Web.ASHX.IrobotBox.BeiKuCommon.ProcessRequest(HttpContext context)
   在 System.Web.HttpApplication.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute()
   在 System.Web.HttpApplication.ExecuteStepImpl(IExecutionStep step)
   在 System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously)
   在 System.Web.HttpApplication.PipelineStepManager.ResumeSteps(Exception error)
   在 System.Web.HttpApplication.BeginProcessRequestNotification(HttpContext context, AsyncCallback cb)
   在 System.Web.HttpRuntime.ProcessRequestNotificationPrivate(IIS7WorkerRequest wr, HttpContext context)
   在 System.Web.Hosting.PipelineRuntime.ProcessRequestNotificationHelper(IntPtr rootedObjectsPointer, IntPtr nativeRequestContext, IntPtr moduleData, Int32 flags)
   在 System.Web.Hosting.PipelineRuntime.ProcessRequestNotification(IntPtr rootedObjectsPointer, IntPtr nativeRequestContext, IntPtr moduleData, Int32 flags)