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 Business Development Manager

▸ Other (non-Software)

You are currently posting as works at Senior Business Development Manager

What would you choose & why?

2 reactions

Posting as :

a Research Associate

You are currently posting as works at Research Associate

What ever happened to the bio-fuels that were supposed to be the Next Big Thing? You never hear about them anymore

2 reactions

Posting as :

a Financial Advisor

You are currently posting as works at Financial Advisor

what’s your go to Starbucks drink? I usually do a grande blonde roast with toffee and soy. Looking to try something new!

1 reactions

Posting as :

a Developer

▸ Engineering

You are currently posting as works at Developer

Do we need to complete all 13 steps in Infosys launchpad Background process. I have completed only 11 documents ( bank and NSR) is pending.

15 reactions

Posting as :

an Associate

▸ Investment & Asset Management

You are currently posting as works at Associate

Looking to get a new laptop for work/casual everyday use. I’ve had a mac ever since college and it’s awful for work/excel. Does anyone have any recommendations? Looking for 12-16 GB RAM. Budget is under $1300 thanks!

2 reactions

Posting as :

works at McKinsey & Company

▸ Strategy

You are currently posting as works at McKinsey & Company

Has anyone else tried Strattera, had success, and a few months later felt like work was a struggle again? Am I imagining it? There are reasons why I should not take stimulants, but I miss that feeling of being a “regular” person at work and so am curious if others have had a similar journey and where you all ended up

2 reactions

Posting as :

an Associate Creative Director

▸ creative

You are currently posting as works at Associate Creative Director

Hi everyone! I’m an ACD/Art with 12 years of experience. Currently looking for my next gig in New York. Unfortunately, most of the times I apply for a job, I’m somehow “overqualified” 😳 (cont)

3 reactions

Posting as :

works at Harman Connected Services

▸ Strategy

You are currently posting as works at Harman Connected Services

What is the job security for people on bench in HCS? I have joined HCS almost a month and a half and yet to be assigned to a project. I am worried if it would negatively affect my position in HCS. Kindly help with your answers.

1 reactions

Posting as :

a Consultant

▸ digital

You are currently posting as works at Consultant

Any opinions on Deloitte Digital in London? Trying to decide if I’d like to transfer

1 reactions

Posting as :

a Senior Associate

You are currently posting as works at Senior Associate

My daughter had tears streaming down here eyes this morning as she begged me not to go to work. I'm heartbroken. The weekend can't come soon enough.

14 reactions

Posting as :

works at EY

▸ Advisory

You are currently posting as works at EY

Got a lot of “undeliverable” packages lately on Amazon. Anyone with similar issue?

2 reactions

Posting as :

an Audit Staff

▸ Audit

You are currently posting as works at Audit Staff

How does a regional firm auditor interested in Deloitte’s forensics practice get their foot in the door?

2 reactions

Posting as :

an Associate

▸ Law

You are currently posting as works at Associate

How do I tell a firm I screened with that another firm I screened with is moving forward with full rounds? I would prefer the former firm, even though the latter firm is ranked higher. Thanks for any advice

3 reactions

Posting as :

an Associate

▸ Law

You are currently posting as works at Associate

Subject Expert

When, if ever, do you add “Esq.” to your name outside of work?

I’m currently in a minor dispute with a company over a credit card overcharge and am wondering if I should have added “Esq.” to my signature in my complaint email lol.

11 reactions

Posting as :

works at IBM

▸ Other (non-Software)

You are currently posting as works at IBM

I have 2 Cathy pacific business class seats on hold from NY to Vietnam via Hong Kong in December through AA miles. If I need to cancel, will I get my aa miles back even with it being booked on a partner ?

1 reactions

Posting as :

works at PwC

▸ Advisory

You are currently posting as works at PwC

How much are you all paying in center based childcare ? Kiddos ages?

2 reactions

Posting as :

works at SS&C Technologies, Inc.

▸ Strategy

You are currently posting as works at SS&C Technologies, Inc.

How to ask a company for counter offer (means how to sentence it correctly)?

I do have multiple offers and want to match the maximum amount with the company that I want to join.

Please share your valuable inputs.

Posting as :

works at PwC

▸ Management Consulting

You are currently posting as works at PwC

Thank you PwC for sponsoring some of us for the Army 10 miler and sponsoring a portion of the race itself

8 reactions

10Y

Posting as :

works at PwC

▸ Management Consulting

You are currently posting as works at PwC

Dobby needs a date in midtown east. No hook up. Civilized date. Suggestions?

1 reactions

10Y

Posting as :

a Strategy Analyst

▸ Management Consulting

You are currently posting as works at Strategy Analyst

Any other firms moving towards a regional model (i.e., you have to work in projects in your region)? Im not excited about working in the Midwest

10Y

Additional Posts in SQL Server

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

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

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