MVEs are more concerned with the satisfaction of those they help than with the considerable points they can earn. They are the types of people you feel privileged to call colleagues. Join us in honoring this amazing group of Experts.
Add your voice to the tech community where 5M+ people, just like you, are talking about what matters.
SELECT dbo.Branch.id, dbo.Branch.name, CONVERT(VARCHAR(10),dbo.Receipt.receiptDate,105) AS SaleDate, dbo.Tafsil.description, dbo.ProductBoughtSupplierDetail.quantity, dbo.Batch.batchNumber FROM dbo.ProductBoughtSupplierDetail INNER JOIN dbo.ProductBoughtSupplier ON ( dbo.ProductBoughtSupplierDetail.productBoughtSupplierId = dbo.ProductBoughtSupplier.id) INNER JOIN dbo.Receipt ON ( dbo.ProductBoughtSupplier.warehouseReceiptId = dbo.Receipt.id) INNER JOIN dbo.Branch ON ( dbo.Receipt.targetBranchId = dbo.Branch.id) INNER JOIN dbo.Batch ON ( dbo.ProductBoughtSupplierDetail.batchId = dbo.Batch.id) INNER JOIN dbo.Tafsil ON ( dbo.Batch.productId = dbo.Tafsil.id) WHERE dbo.Receipt.receiptType = 5 AND dbo.ProductBoughtSupplier.invoiceReceiptId IS NULL ;
|LTrim & Double Space Correction||5||40|
|Run an action on recently added records to a table||13||62|
|sql2016-WIn10: standard,for SQL servc-account..||51||29|
|How can I get the entire database script?||7||13|