1answer.
Ask question
Login Signup
Ask question
All categories
  • English
  • Mathematics
  • Social Studies
  • Business
  • History
  • Health
  • Geography
  • Biology
  • Physics
  • Chemistry
  • Computers and Technology
  • Arts
  • World Languages
  • Spanish
  • French
  • German
  • Advanced Placement (AP)
  • SAT
  • Medicine
  • Law
  • Engineering
jeka57 [31]
3 years ago
9

Develop a stored procedure that will take a state abbreviation as a parameter and list the name of the state, vendor, and total

amount still owed on invoices for the vendor with the highest amount still owed in that state, i.e. list the vendor (along with their state and amount owed) with the most money still owed for a given state. (List only vendors to whom a positive amount is still owed; omit vendors to whom no amount is owed). The Canvas assignment includes a link to a script for a partially completed stored procedure called owed_to_state_vendors. Review the code, including the comments, to understand the requirements of the stored procedure. You will complete the stored procedure, using the comments as a guide. Use of a CTE is advised to accomplish this task.
Computers and Technology
1 answer:
Aleonysh [2.5K]3 years ago
6 0

Answer:

ummm so sorry

Explanation:

i will try to help u just give me a sec

You might be interested in
Type the correct answer in each box. Spell all words correctly, and use numerals instead of words for numbers. If necessary, use
aliya0001 [1]

Answer:

125.28₁₀ in hexadecimal = 7D.47AE147AE1₁₆

Step-by-Step Explanation:

To convert decimal number 125.28, we convert its integer and fraction part individually and then add them to get the equivalent hexadecimal number, as below:

To convert integer 125 to hexadecimal, follow these steps:

Divide 125 by 16 keeping notice of the quotient and the remainder. Continue dividing the quotient by 2 until you get a quotient of zero.

Then just write out the remainders in the reverse order to get the equivalent hexadecimal number.

125 / 16 = 7 with remainder 13 (D)

7 / 16 = 0 with remainder 7

Here is the answer to 125 decimal to hexadecimal number:

7D

For converting decimal fraction 0.28 to hexadecimal number, follow these steps:

Multiply 0.28 by 16 keeping notice of the resulting integer and fractional part. Continue multiplying by 16 until you get a resulting fractional part equal to zero (we calcuclate upto ten digits).

Then just write out the integer parts from the results of each multiplication to get equivalent hexadecimal number.

0.28 × 16 = 4 + 0.48

0.48 × 16 = 7 + 0.68000000000001

0.68000000000001 × 16 = 10 (A) + 0.88000000000011

0.88000000000011 × 16 = 14 (E) + 0.080000000001746

0.080000000001746 × 16 = 1 + 0.28000000002794

0.28000000002794 × 16 = 4 + 0.48000000044703

0.48000000044703 × 16 = 7 + 0.68000000715256

0.68000000715256 × 16 = 10 (A) + 0.88000011444092

0.88000011444092 × 16 = 14 (E) + 0.080001831054688

0.080001831054688 × 16 = 1 + 0.280029296875

Here is the answer to 0.28 decimal to hexadecimal number:

0.47AE147AE1

Therefore, decimal number 125.28 converted to hexadecimal is equal:

7D.47AE147AE1

5 0
2 years ago
Which of the following is an example of a consumer service? computer builder motorcycle manufacturer cabinet maker air condition
Zanzabum
Motorcylce manufacturer
6 0
3 years ago
Read 2 more answers
If you wanted to make certain numbers in a spreadsheet stand out, you should _____.
almond37 [142]
Make the numbers in bold and/or underlined
3 0
2 years ago
Read 2 more answers
In Subtractive empathy, the counselor responses gives back less (or distorts) than what the client has said. slightly add someth
SashulF [63]

Answer:

gives back less (or distorts) than what the client has said.

Explanation:

Emotional intelligence can be defined as the cognitive ability of an individual or person to be able to recognize his or her emotions, have an understanding of the message being conveyed and knowing how these emotions affect the people around him or her.

Basically, there are five (5) main characteristics or features of emotional intelligence and these are;

I. Motivation.

II. Self-awareness.

III. Social skills.

IV. Self-regulation.

V. Empathy.

Empathy simply means putting yourself in a person's position, depicting how you will feel if you were in his or her situation. Also, empathy depicts getting the perspective of a thing through another person's lens, eyes or ears.

There are three (3) main types of empathy and these includes;

I. Basic (interchangeable empathy).

II. Additive empathy.

III. Subtractive empathy.

In Subtractive empathy, the counselor responses gives back less (or distorts) than what the client has said.

This ultimately implies that, subtractive empathy requires the counselor using an inappropriate listening or influencing skills.

5 0
2 years ago
Aubrey uses the following formula to calculate a required value. Which elements of the formula use mixed cell referencing?
iris [78.8K]

Answer:

$1A

brainiest plz

Explanation:

The elements of a formula only can have the following format:

1) Letter Number as C1

2) Letter $ Number as A$1

3) $ Letter Number as $A1

4) $ Letter $ Number as $A$1

The element $1A is not in the format

5 0
2 years ago
Read 2 more answers
Other questions:
  • strategy that is used to help improve the chances that your site will be found by search engines is known as search engine
    12·1 answer
  • "In an artificial neural network, what input values will cause the neuron below to produce an output of 1". Group of answer choi
    12·1 answer
  • Complete the function void update (int *a, int *b), which reads two integers as argument, and sets a with the sum of them, and b
    8·1 answer
  • What was the original motivation for developing the internet?
    7·1 answer
  • Cual es la definición de grouded?​
    7·1 answer
  • Determine whether the phrase below is a sentence or a fragment.
    12·1 answer
  • How do you think Beyoncé choreography has/will influence the future of dance?
    9·2 answers
  • Does any of yall play rob lox?
    5·2 answers
  • Write a format operation that builds a string for the float variable amount that
    11·1 answer
  • Which sentence describe internet safety precautions?
    5·1 answer
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!