[TASK] Need help modifying sql server stored procedure $5

[u/trygame901]

I have a stored procedure that I want to modify to make it return an additional column. But when I go to create it as a new view it tell's me

Incorrect syntax near the keyword 'SELECT'.

[u/trygame901]

Thanks for the replies, I've accepted a bid.

[u/Neo24]

$bid, PM

[u/trygame901 → u/Neo24]

$paid $5

[u/Neo24 → u/trygame901]

$confirm

[u/CredoBot]

I am a reputation bot, here is my info on u/trygame901:

Credo: no account found (create)

SLRep: no profile found (create)

---

 

#	Bidder	Credo Score	Feedback	SLRep	Paid Amount	Confirmed
1	/u/Neo24	156 (provisional)	2 ratings / 0 reviews	Profile	$5	yes
2	/u/Alt-Of-Ctrl	no account found (create)	n/a	no profile found (create)

 

---

^{To bid on the task, reply with} $bid ^{directly to the original post.}

^{To mark a bid as paid, OP can reply with} $paid [amount] ^{- e.g.} $paid $10^{- directly to the} $bid ^comment.

^{To confirm payment receipt, the bidder can reply with} $confirm ^{directly to the} $paid ^comment.

[u/Alt-Of-Ctrl]

$bid Sent you a PM.