Veeam® is happy to provide a FREE NFR server license to certified engineers, trainers, and bloggers. It allows for the non‑production use of Veeam Agent for Microsoft Windows. This license is valid for five workstations and two servers.
Update [Statements To Print] Set [Partial]=(Select isnull(Sum(Payment.[Payment Amount]), 0) from Payment Inner Join Orders On Orders.[Order Number]=Payment.[Invoice Number] INNER JOIN [Statements To Print] ON Orders.[Customer Number]=[Statements To Print].[Invoice Number] Where Orders.Paid = 0 And Orders.Deleted = 0 and orders.[Customer Number]='0'
Update StatementsToPrint INNER JOIN Orders ON StatementsToPrint.InvoiceNumber = Orders.OrderNumber INNER JOIN Payment ON Payment.InvoiceNumber=Orders.InvoiceNumber Set StatementsToPrint.Partial=Sum(Payment.PaymentAmount) Where Orders.Paid = 0 And Orders.Deleted = 0 and orders.CustomerNumber='0'
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.