select i.[orderid] ,i.[qty] ,i.[qty_unitMsr] ,i.[intIdentifier] ,i.[lineItem_Table] ,i.[lineItem_ID] ,i.[title] ,i.[sizeDesc] ,i.[itemDesc] ,i.[itemIdentifier] ,coalesce([maxOrderQty],null,0) maxOrderQty ,i.[datestamp] ,coalesce([shp_qty],null,0) shp_qty ,i.[shp_qty_unitMsr] ,i.[notShipped] ,i.[fseOpportunityStatus] ,i.[lineItemComment] from FSLibrary_07022024..tbl_POS_orderlineitems i with(nolock) inner join FSLibrary_07022024..tbl_POS_orders o on i.orderId = o.orderId where o.ownerId = 241 and o.fsl_tablecode = 'MFR' and i.dateStamp >= '2021-01-01' order by o.orderdate select i.* from tbl_POS_orderLineItems i with(nolock) where i.orderid = and i.lineItem_ID = and i.itemIdentifier = and i.itemDesc = INSERT INTO tbl_POS_OrderLineItems ([orderid] ,[qty] ,[qty_unitMsr] ,[intIdentifier] ,[lineItem_Table] ,[lineItem_ID] ,[title] ,[sizeDesc] ,[itemDesc] ,[itemIdentifier] ,[maxOrderQty] ,[datestamp] ,[shp_qty] ,[shp_qty_unitMsr] ,[notShipped] ,[fseOpportunityStatus] ,[lineItemComment]) VALUES (#orderid# ,#qty# ,'#qty_unitMsr#' ,'#intIdentifier#' ,'#lineItem_Table#' ,#lineItem_ID# ,'#title#' ,'#sizeDesc#' ,'#itemDesc#' ,'#itemIdentifier#' ,#maxOrderQty# ,'#datestamp#' ,#shp_qty# ,'#shp_qty_unitMsr#' ,#notShipped# ,'#fseOpportunityStatus#' ,'#lineItemComment#')