Your membership is pending review by Bowl Admins

Posting as :

a Systems Analyst

▸ SQL Server

You are currently posting as works at Systems Analyst

How do you personally explain the difference between Cross Apply and Cross Join?

Posting as :

works at

You are currently posting as works at

Posting as :

ActiveOps 1

You are currently posting as ActiveOps 1

Cross join is between two tables or two sub queries, whereas the cross apply is most commonly used to join a table to the results of a TVF.

Having said that, a cross join is every possible combination from both tables or sub queries, so isn’t really comparable to the cross apply. You would really be comparing an inner join to a cross apply.

In terms of the mechanics, the inner join and cross apply are similar by returning matching rows from both outputs.

1 reactions

Posting as :

Provest 1

You are currently posting as Provest 1

An apply can supply a single row data or many to already existing data. A join can supply multiple rows and and create new ones depending on if it’s an inner, left, or right. Applies are useful for giving a single row of results sorted by date or ID desc

Posting as :

a Senior Consultant

▸ human capital & hr consulting

You are currently posting as works at Senior Consultant

Best month to find an apartment? Currently a nomad working abroad so want to strategically time my move back to NYC. Lived here for 5 years but always stuck in the summer rental cycle

1 reactions

Posting as :

an ESG Analyst

▸ Investment & Asset Management

You are currently posting as works at ESG Analyst

Is it normal for a big4 to take over two months in the interview process? Since end of January I've had five interviews w team members, including with the partner who leads the practice I'd be joining. Still no word. I've gotten nothing but positive feedback with the in-house recruiter I'm working with. Is this normal? I'd love to work for this firm and don't want to be annoying :)

Posting as :

a Devops Engineer

▸ Engineering

You are currently posting as works at Devops Engineer

Hello Fishes,
Looking for a job change in DevOps role, please help with referrals.
Experience:5 years
Skillset: Linux, Docker, K8s, Python/Shell, Jenkins/GitLab CI, release management.
Notice period: 1 month

2 reactions

Posting as :

works at Capgemini

▸ Strategy

You are currently posting as works at Capgemini

What is the difference between KPMG FTS and FTE?

4 reactions

Posting as :

a Consultant

▸ Engineering

You are currently posting as works at Consultant

In KPMG india salary structure in performance bonus what do you mean by annual target earning and annual maximum potential earning?? How much is the average percentage I can expect ??

2 reactions

Posting as :

a Senior Consultant

▸ Strategy

You are currently posting as works at Senior Consultant

Any body joining cognizant recently received any joiners kit (stuff other than IT assets) ? Cognizant

3 reactions

Posting as :

an Associate Attorney

▸ Law

You are currently posting as works at Associate Attorney

Anyone have insight on how to move in-house at EY?

1 reactions

Posting as :

a Senior Analyst

▸ Technology

You are currently posting as works at Senior Analyst

Recommendations for polos/ short sleeve buttons?

Posting as :

a Senior Tax Accountant

▸ tax

You are currently posting as works at Senior Tax Accountant

Enthusiast

9/22 Thread (BC):

4 reactions

Posting as :

works at Dxc.technology

▸ Other

You are currently posting as works at Dxc.technology

Hi, Anyone joining TCS on november 23rd at hyderabad

1 reactions

Posting as :

works at Strategy&

▸ Strategy

You are currently posting as works at Strategy&

McKinsey & Company Strategy& people are getting a $4500 special recognition bonus on top of the annual bonus!🤑

How are y’all firms doing?

Boston Consulting Group McKinsey & Company Kearney Oliver Wyman Roland Berger

5 reactions

Posting as :

works at Infosys

▸ Strategy

You are currently posting as works at Infosys

What is the average yearly hike in Fis Global for laterals?FIS Global Infosys Tata Consultancy

2 reactions

Posting as :

works at KPMG

▸ strategy

You are currently posting as works at KPMG

Just sold all my remaining LTC. Bought at $50. Waiting for another dip of ETH below $707 then buy ETH and buy LTC if below $80...

Posting as :

a Software Engineer

▸ Engineering

You are currently posting as works at Software Engineer

Hi Fishes & Sharks
My office is near cubbon park so can you please let me know which are good areas and get flat in reasonable rent.
Also any good colive space too is also fine for me but distance should not be more than 6-7 km.
Thanks in advance!!!

4 reactions

Posting as :

Xuing Xang

▸ Strategy

You are currently posting as works at Xuing Xang

Hey how to get pluralsight access?

Posting as :

works at EY

▸ Management Consulting

You are currently posting as works at EY

Does anyone know how to change the city that you are affiliated with on this app?

1 reactions

10Y

Posting as :

a Director

▸ account management

You are currently posting as works at Director

Digital killed the advertising business.
Agree or Disagree?

4 reactions

Posting as :

an Investment Banking Associate

▸ investment banking

You are currently posting as works at Investment Banking Associate

Does London banks do drug testing for new hires? Not a new hire but looking to switch offices within the company, thanks!

Not a drug hardo at all but sometimes enjoys the occasional 420 on weekends

Posting as :

a Software Engineer

▸ Engineering

You are currently posting as works at Software Engineer

Hi Fishes, please use the chart to calculate your in-hand salary. Tata Consultancy Cognizant Accenture India Infosys EPAM Systems EPAM Anywhere 🇮🇳

13 reactions

Posting as :

a Director

▸ strategy

You are currently posting as works at Director

Cross post—- 🐠 need your help. Has anyone deployed Oracle iProcure or P2P can you share your experiences and what functionality the platform is missing compared to Ariba and Coupa. Thx so much

Additional Posts in SQL Server

Posting as :

works at ActiveOps

▸ Design

You are currently posting as works at ActiveOps

I am currently recruiting for DBA’s for both SQL Server and Azure SQL DB. What questions should I be asking?

1 reactions

Posting as :

Kenya Jerdine

▸ Data Science

You are currently posting as works at Kenya Jerdine

Hello All, if you had the opportunity to explain SQL in a nut shell, what would you say.

Scenarios would be helpful.

2 reactions

New to Fishbowl?

Download the Fishbowl app to
unlock all discussions on Fishbowl.

New to Fishbowl?

"" is an unusual email domain. If correct, please proceed to the next step

Enter work email

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

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

Related Posts

Additional Posts in SQL Server

New to Fishbowl?

Trending Topics

How do you personally explain the difference between Cross Apply and Cross Join?

An apply can supply a single row data or many to already existing data. A join can supply multiple rows and and create new ones depending on if it’s an inner, left, or right. Applies are useful for giving a single row of results sorted by date or ID desc

Related Posts

Additional Posts in SQL Server

New to Fishbowl?

New to Fishbowl?

Trending Topics

New to Fishbowl?

Embed this post

Download the Fishbowl app

Sign up for free to view this conversation on Fishbowl

Sign up for free to continue using Fishbowl

For account settings, visit Fishbowl on Desktop Browser or

General

Legal

Download the
Fishbowl app