Write a select statement that returns the lnvoicenumber

Assignment Help Computer Engineering

Reference no: EM133360624

Assignment: Write a SELECT statement that returns the lnvoiceNumber and balance due for every invoice with a non-zero balance and an InvoiceDueDate that's less than 30 days from today.

code:

select InvoiceNumber, (InvoiceTotal - CreditTotal) as Balance, InvoiceDueDate
from Invoices
where
InvoiceDueDate < CONVERT(datetime, dateadd(D, -30, getdate()), 120)
AND (InvoiceTotal - CreditTotal) <> 0

Modify the search expression for InvoiceDueDate from the solution for exercise 2. Rather than 30 days from today, return invoices due before the last day of the current month.

Reference no: EM133360624

Questions Cloud

Analysis of how to calculate sales : Analysis of how to calculate sales and what are the factors to consider in coming up with the amount of revenues.

Write java code which will gather sales amounts for the week : Write Java Code which will gather sales amounts for the week. It should use a separate class to display the total, average, highest, and lowest sales amounts

Pricing and cost structure for hardware and software : Nintendo Canada was launching its new Game Boy Color hand-held gaming system with the following pricing and cost structure for hardware and software

Four seasons that makes them directly competitive : For each competitor describe what is similar to Four Seasons that makes them directly competitive

Write a select statement that returns the lnvoicenumber : Write a SELECT statement that returns the lnvoiceNumber and balance due for every invoice with a non-zero balance and an InvoiceDueDate that's less than 30 days

Design a chain of custody form : Design a Chain of Custody (COC) form, as well as an Evidence Inventory Form (which lists all the pieces of physical evidence in a case).

Which type of advertising is more effective : How can you determine which type of advertising is more effective?

Types of consumers for ceramic products and services : Describe the profile of the following types of consumers for ceramic products and services:

Determine how it is similar to the nist sp 800-100 model : Search the web using the following string: information security management model -"maturity" This search will exclude results that refer to "maturity."

User Account

All Pages