Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.
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())
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
Join the community of 500,000 technology professionals and ask your questions.