Using declare, set function in SQL and in my declare function I am returning the following error:
“Cannot coerce expression (SELECT SUM(…”

Can’t find anywhere as to what this error means.

Although when I run the set query by itself, the sql does run correctly. But the error seems to occur when I add the SET function and using an open and close parenthesis around the query I am setting my
Variable to. Any idea as to what is causing this error?

Posting as :
works at
You are currently posting as works at

Related Posts

Doctor just prescribed Wellbutrin to add onto my adderall. Has anyone tried this combo? What effect did adding Wellbutrin have on you?

like

Hello let's like each other's post to build connection via DM!

like

Any openings for a commercial/corporate counsel in East Bay- near San Ramon?

I have recently given interview at Microsoft.
HR provided the feedback as I am not rejected bit not fit for the role so they have put me in talent plus pool. What should I expect next and does this mean that I may get the offer ?

like

Hi Everyone !!!

This June I completed my 9 months at Career Level 12 and Sub Level 3 I.e, CL 12.3 at
Accenture Operations. My Annual Talent Discussion and One-on-One with People Lead is complete as of last week.

I have 3 questions now :
1. When can I expect to move to 12.2 ?
2. What is the general hike I can expect ? And when it is reflected ?
3. When will be the variable pay will be paid out ?

Can anyone here help me with this performance cycle part ? I am really confused.

Accenture

like

I just had to send my husband away in an ambulance. I’m not allowed to go with him or even go to the hospital. I don’t know what to do. I can’t even be there for my husband.

like

What are the companies willing to sponsor visas into Singapore? Any referral will be helpful thanks.

like

male fishies: where do you guys buy your ties?

like

Anyone works in Facebook? What’s the pay like for finance roles?

like

Can someone recommend some marketing and design blogs? I am working on a project and my creative juices just aren't flowing.

like

Anyone try Brooklyn Biltong? Thoughts?

Welcome gift from Target!! They give you a lot of stuff. I was surprised by it.

Post Photo
like

Hi Fishes,

Got an offer from TCS for the Bank of America project. Is it a good project? And which location should I choose Bangalore or Mumbai?

like
like

Paralegals: My firm is looking for a paralegal, and I see the job posting advertising the salary as $65-$75k, with benefits. Is this a good salary for a paralegal (Greater LA area)? I’m not the decision maker, but it’s been a few weeks with very few applicants. I’m curious if there’s something hurting the firm in its search.

like

Any choice Marriott properties in NYC? Hard to distinguish what's a good pick. Trying to stay below 300 USD a night.

Just a quick tip for everyone traveling - always take a picture of your receipts.

like

Hopefully the lines are shorter than the covid drive-thru testing centers 😬

Post Photo
like

Additional Posts in Data Science

Want to re start my carrier as a data analyst in any good corporate after six years, is it possible?

like

Hello! I hope you had a great thanksgiving! For those that have pivoted into the technology field, how did you start? To be more specific I’m looking to pivot from higher education to data analytics and would like to know how to go about that. Are their particular certificates I need to get? Any direction would be appreciated. Thank you

like

Hey everyone, using SQL does anyone know how you can sum the top N records and return one output? Is a RANK function needed? For example top 10 items with sales all summed to return one value.

like

Are there any data science certifications that people can recommend which will be well received/recognized on resumes? Thanks in advance!

Is anyone hiring? I need a new job

like

Has anyone used the website DataCamp? I’ve been using it to learn Data Science because my work provides free access and have been enjoying it. Anyone else have experiences with DataCamp? I’ve have been working through the “Python for Data Science” course.

like

Does anyone know where I can get salary range demographic data? Thank you.

New to Fishbowl?

Download the Fishbowl app to
unlock all discussions on Fishbowl.
That was just a preview…
Sign Up to see all discussions
  • Discover what it’s like to work at companies from real professionals
  • Get candid advice from people in your field in a safe space
  • Chat and network with other professionals in your field
Sign up in seconds to unlock all discussions on Fishbowl.

Already a user?
Login here

Share

Embed this post

Copy and paste embed code on your site

Preview

Download the
Fishbowl app

See what’s happening in your industry
from the palm of your hand.

A phone with Fishbowl app

Scan your QR code to download
Fishbowl app on your mobile

Download app

Sign up for free to view this conversation on Fishbowl

By continuing you agree to Terms of Use and Privacy Policy

Already have an account? Log in

Sign up for free to continue using Fishbowl

By continuing you agree to Terms of Use(New) and Privacy Policy(New)
Messaging rates may apply

Already have an account? Log in

For account settings, visit Fishbowl on Desktop Browser or

General

Legal