Untitled

mail@pastecode.io avatar
unknown
sqlserver
2 years ago
460 B
3
Indexable
Never
SELECT 
    qtyonhand, 
    CONCAT('s', serialnumber) AS Serial,
    Product,
    Size,
    Bin,
    Location,
    Previousbin AS PrevBin,
    PreviousLocation AS PrevLoc,
    Lastscandate,
    Username AS User
FROM
    shard.inventoryitemupdate
WHERE
    username = 'Rosalinda Negrete'
        AND lastscandate >= '2022-12-03 04:00:00'
        AND lastscandate <= '2022-12-03 16:30:00'
        AND qtyonhand = 1
        #GROUP BY Bin
ORDER BY lastscandate ASC