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, 21.06.2019 21:40
Which is a benefit of getting information from a government website? a. the information will be easy to understand. ob. the information will be the most current. oc. the information can be trusted.
Answers: 1
question
Computers and Technology, 22.06.2019 16:10
Drag each label to the correct location on the imagelist the do’s and don’ts of safeguarding your password.keep yourself loggedin when you leave your computer.don’t write your password down and leave it whereothers can find it.share your password with your friends.each time you visit a website,retain the cookies on your computer.use a long password with mixed characters.
Answers: 1
question
Computers and Technology, 22.06.2019 21:00
Kirk found a local community college with a two-year program and he is comparing the cost with that of an out-of-state two-year school. what is the expected total cost for one year at the local community college if kirk lives at home? what is the expected total cost for one year at the out-of-state school if kirk lives on campus?
Answers: 2
question
Computers and Technology, 23.06.2019 10:50
Your friend kayla is starting her own business and asks you whether she should set it up as a p2p network or as a client-server network. list three questions you might ask to kayla decide which network to use and how her answers to those questions would affect your recommendation.
Answers: 2
You know the right answer?
Use ap;
declare @date1 smalldatetime;
declare @date2 smalldatetime;
select @dat...
Questions
question
Mathematics, 23.11.2019 09:31
Questions on the website: 13722367