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

Hi everyone, I will be highly obliged if someone can share the interview questions for data scientist/decision consultant role in fractal

like

Anyone from RBS, tech stack Java API?

Hi,
What could happen if we do not work in the current organisation after putting down the papers?
Though the LWD is yet to be received from the Manager.
Thanks

Hi Fishes,
I am an BScIT Graduate with experience of 5 years in BPO(Customer Service) currently working with TCS.

Ive been learning to be a data scientist (Ineuron Full Stack Data Science)

Considering having a hands an experience on 4-5 Projects with Internship Certificates, Is it possible to get an opportunity directly into a Data Scientist Role(NLP/ML)?

Or should i go and work as an Analyst first and then look for an opportunity at more adv role?
What would be your inputs/suggestions?

like

More than halfway through a 90 in 90 and I’m so grateful for NY AA and that there are so many meetings! Also 90 in 90 is actually kinda great

like

Just went through a cancer scare.
Looks like it was a false alarm, but it threw me for a loop. Can’t sleep, can’t work out, back to back habits, while theoretically I should be exuberant...

like

If you haven’t done so yet then you should check out Class Pass. Way better than going to some crappy globogym.

like

from God import pandemic
From China import coronavirus, mortality_rate

covid_19 = pandemic.coronavirus.set_mortality(mortality = 1.)

like

Hi Fishes,
My Appraisal is due this september. Can anyone of you tell me how much hike can i expect.
Cctc:6.5
Designation:Engineer
Exp:2.6
I joined in jan2020 but the training period of our entire batch was extended due to covid. Hence getting first appraisal in sept 2021.
Thanks in Advance😀

I’m a 9th year in a mostly litigation-based practice group at a one-tier partnership firm. My group’s billable hours have been low the last few years, so making partner will be nearly impossible, and a counsel position is not viable long-term in my group. What’s the best option here if partnership is the ultimate goal? Try to get a NEP/counsel position at another firm, which is likely difficult in my market, or offer to take a class cut by a few years?

likehelpful

Hi All,

My sister is searching for a job. She is currently working as PMO in Infosys from last 2 years (she has only 2 years experience). Can someone please provide referral for PMO role in Capgemini Pune?

Thanks in advance... 😊

like

Hi Guys,
I have multiple offers including offers from TCS.
But the TCS offer is less. So I'm not planning to join. Will the company block me if I do not join.

like

Joined at 502 in JPMC in mid July (in Operational Risk). 6 YOE (4 in audit, 2 in BPO). Haven't really started working in the true sense yet. Objective setting discussion just began for this year. Wondering what to expect from performance appraisal considering these facts in terms of hike and bonus. LOB - Corporate.

like

How is the United States Delivery center? They are recruiting me for that. Good or bad? anything to be aware of?

like

Hello. Just curious on what's the salary ceiling for a manager position at Deloitte? Received a verbal offer and waiting on written offer. I was told by a recruiter that M at Deloitte doesn't make more than 180. Just curious if that's actually true and if anyone had experience negotiating higher salary than 180.

like

Joined in Oct for SAP functional. Now one manager who interviewed me reached out that there is a training material developer project which will start on 20 nov for Oracle timeline is 2 months only and SAP projects are in pipeline there was one coming but no guarantee if its final and if it has to come it will be in this month because in dec new projects do not onboard. I have worked on oracle in the past but now am fully into SAP. Should I take this project or wait until Jan for SAP project?

like

Accenture India Lately there are so many hr openings with Accenture in almost all portals naukri, indeed, monster, linked in etc but there is not a single response infact I have the cc number wherein status is reflecting as hr will contact you ..but I have not received any revert, tried emailing the hr through a reference got an auto email stating out of office nd shared his contact number to connect, when tried calling hr,he was annoyed but I guess he forgot that he himself has shared the number. Accenture Ind

like

Additional Posts in Data Science

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

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

like

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

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

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