subject

Use ap;
declare @date1 smalldatetime;
declare @date2 smalldatetime;
select @date1 = min(invoiceduedate), @date2 = max(invoiceduedate)
from invoices
where invoicetotal - paymenttotal - credittotal > 0;
if @date1 < getdate()
if @date2 < getdate()
begin
print 'earliest past due date: ' + convert(varchar, @date1, 1);
print 'latest past due date: ' + convert(varchar, @date2, 1);
end;
else
print 'earliest past due date: ' + convert(varchar, @date1, 1);
else
print 'no invoices past due';

if the current date is 04/04/16, the earliest invoice due date for invoices with unpaid balances is 02/09/16, and the latest invoice due date for invoices with unpaid balances is 03/20/16, what will be printed by this script?

ansver
Answers: 2

Other questions on the subject: Computers and Technology

image
Computers and Technology, 21.06.2019 17:00, xo216aaliyah216xo
How can data be added to a new table in data base
Answers: 1
image
Computers and Technology, 21.06.2019 19:30, LuxTheGirl3070
Entering key dates from your course syllabi test and quiz dates, assignments due dates in your planner can you manage your schedule by allowing you to see commitments ahead of time.
Answers: 3
image
Computers and Technology, 23.06.2019 16:10, alexis9658
What is the ooh? a. omaha occupation handbook b. online occupational c. occupations online d. occupational outlook handbook select the best answer from the choices provided
Answers: 3
image
Computers and Technology, 23.06.2019 23:30, ayjahj
What can you prevent issues related to downloading content form the internet
Answers: 1
You know the right answer?
Use ap;
declare @date1 smalldatetime;
declare @date2 smalldatetime;
select @dat...

Questions in other subjects:

Konu
Mathematics, 17.11.2020 19:40