Se7enSquared
10/18/2019 - 10:57 PM

SQL Snips for dbprod

various short SQL recipes for work

/* UPDATE PART TO OBSOLETE*/
USE dbprod;
UPDATE CCM_Components SET HardWareStatusID = 3, UpdatedBy = 'auth\gray', UpdatedOn = '2019-04-02 09:19:00' WHERE HPPartNumber = '911603-591';


/* SELECT STATUS INFO FOR PART*/
USE dbprod;
SELECT C.HPPartNumber, C.Description, H.HardwareStatusID, H.HardwareStatusDesc, C.SupplierLastShipDate FROM CCM_Components AS C JOIN CCM_HardwareStatusMaster 
AS H ON C.HardWareStatusID = H.HardwareStatusID  
WHERE HPPartNumber LIKE '797257-581' ORDER BY C.HPPartNumber;


/* UPDATED TODAY */
USE dbprod;
SELECT * FROM CCM_Components WHERE UpdatedBy = 'auth\gray' AND UpdatedOn >= '2019-04-02 00:00:00';

/* WHERE-IN SELECT */
USE dbprod; SELECT HPPartNumber, SupplierLastShipDate, HardwareStatusID FROM CCM_Components WHERE HPPartNumber IN ('L34707-611','L34707-612','L34707-621','L34707-622','L34707-911')