Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.
SELECT st.storeid, st.storename, gp.description, rp.quantity, rp.unitcost FROM linkx.dbname.dbo.iqclerk_purchaseorders po INNER JOIN linkx.dbname.dbo.iqclerk_receiving ir ON ir.purchaseorderid = po.purchaseorderid INNER JOIN linkx.dbname.dbo.iqclerk_receivingandproducts rp ON ir.receivingid = rp.receivingid INNER JOIN linkx.dbname.dbo.iqclerk_stores st ON ir.receiverstoreid = st.storeid INNER JOIN linkx.dbname.dbo.iQclerk_GlobalProducts gp ON rp.globalproductid = gp.globalproductid WHERE vendorid = '22' AND LEFT(gp.categorynumber, 6) = '101010' AND MONTH(ir.datereceived) = month(GETDATE()) AND year(ir.datereceived) = year(GETDATE())
|Count UNIQUE results in a field from an MS Access database||6||41|
|How to order Highest and lowest value rows alternatively in SQL Server ?||4||24|
|How to create a delete query to delete entire records||2||11|
Join the community of 500,000 technology professionals and ask your questions.
Connect with top rated Experts
10 Experts available now in Live!