Select SD.partnum as 'Part No.',SD.rev as 'Rev.',SD.descript as 'Description',SD.qtyship as 'Qty.Ship.',SD.bol_no as 'BOL',SD.SalesOrderID as 'SO',SD.so_item_no as 'Item',
SC.customername as 'Cust',SC.shipmethod as 'Carrier',SC.boxes as 'Boxes', SC.tracking as 'Tracking',convert(varchar(25),Sc.shipdate,105) as 'Date'
from TC01SalesOrderDetail SD,tr02shipconfirm SC
where SD.customergroupcode=@strShip_cust and SD.bol_no=SC.bol_no and SD.so_item_no=SC.so_item_no and SD.SalesOrderID=Sc.SalesOrderID and Sc.shipdate
between @strFromDt and @strToDt and SD.partnum=@str_txtPart order by Sc.shipdate,SD.bol_no,SD.so_item_no,SC.boxes
It will return some output.Referring the above Query ,How to update the Customername as XXY for the particular partnum?
Is this possible to invoke the whole Query in the update statement?
View Complete Post