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

Another question on Computers and Technology

question
Computers and Technology, 22.06.2019 11:30
What does a cascading style sheet resolve a conflict over rules for an element? a. the rule affecting the most content wins b. the rule affecting the most content loses c. the rule with the most specific selector loses d. the rule with the most specific selector wins
Answers: 2
question
Computers and Technology, 23.06.2019 05:00
Which best explains why a digital leader would join a society specializing in technology
Answers: 1
question
Computers and Technology, 23.06.2019 22:20
What is a programming method that provides for interactive modules to a website?
Answers: 1
question
Computers and Technology, 24.06.2019 10:00
(, urgent need): how do i change my username
Answers: 1
You know the right answer?
Use ap;
declare @date1 smalldatetime;
declare @date2 smalldatetime;
select @dat...
Questions
question
Mathematics, 19.01.2021 22:50
question
Biology, 19.01.2021 22:50
question
Mathematics, 19.01.2021 22:50
question
English, 19.01.2021 22:50
Questions on the website: 13722367