$--$ Create the stored procedure

CREATE PROCEDURE cs$431\_$question$4$

AS

BEGIN

$--$ Declare variables

DECLARE @outputString NVARCHAR$($MAX$)$

DECLARE @vendor$\_$id INT

DECLARE @vendor$\_$name NVARCHAR$(100)$

DECLARE @invoice$\_$number NVARCHAR$(50)$

DECLARE @balance$\_$due DECIMAL$(18,2)$

$--$ Initialize the output string

SET @outputString $=\text{'}\text{'}$

$--$ Declare and set up the cursor

DECLARE invoice$\_$cursor CURSOR FOR

SELECT v$.$vendor$\_$id$,$ v$.$vendor$\_$name, i$.$invoice$\_$number, $($i$.$invoice$\_$total $-$ i$.$payment$\_$total$)$ AS balance$\_$due

FROM invoices i

JOIN vendors v ON i$.$vendor$\_$id $=$ v$.$vendor$\_$id

WHERE $($i$.$invoice$\_$total $-$ i$.$payment$\_$total$)>=0--$ Filter invoices with a balance due $>=$ $$0$

$--$ Open the cursor

OPEN invoice$\_$cursor

$--$ Fetch data into variables and build the output string

FETCH NEXT FROM invoice$\_$cursor INTO @vendor$\_$id$,$ @vendor$\_$name, @invoice$\_$number, @balance$\_$due

WHILE @@FETCH$\_$STATUS $=0$

BEGIN

SET @outputString $=$ @outputString $+$ CAST$($@vendor$\_$id AS NVARCHAR$(10))+\text{'}|\text{'}+$

@vendor$\_$name $+\text{'}|\text{'}+$

@invoice$\_$number $+\text{'}|\text{'}+$

CONVERT$($NVARCHAR$(20),$ @balance$\_$due$)+\text{'}//\text{'}$

FETCH NEXT FROM invoice$\_$cursor INTO @vendor$\_$id$,$ @vendor$\_$name, @invoice$\_$number, @balance$\_$due

END

$--$ Close and deallocate the cursor

CLOSE invoice$\_$cursor

DEALLOCATE invoice$\_$cursor

$--$ Display the output string

SELECT @outputString AS Result

END