What is the cash_pickups table? Seems to be in the plan but not the query? Is one of those tables a view? Or do you maybe have a referential integrity...

I'd especially like to understand why a derived table is ok but a CTE is not.

DonlSimpson (2/10/2015)

---

Is this a professional forum, or one for hobbyists? I realize there are plenty of developers who get things dropped in their laps that are outside their expertise,...

How many rows in floats and how many is it usually trying to delete?

That's why he is applying that condition in the LEFT JOIN clause.

If there is a matching 'MATH' program, it shows it along with the applicant.

If there is no matching program,...

Being that that formula is basically just a mathematical calculation, there really wouldn't be much update to be done.

In your case you may want to change this to an inline...

CELKO (2/8/2015)

---

I want him to leave with more than a kludge he does not understand, so that when he does have "experience, authority or gravitas to engage for a database...

aaron.reese (2/8/2015)

---

Well said Jeff,

@joe, it would be lovely to live in your SQL bubble where all RDMS is built and managed by people with 20 years experience, a...

It depends on the output you want

Do you want one result set where each row has either a toy or a widget, and the client they are linked to? ...

A sample with closer to the format you requested

CREATE TABLE #MachineGroups (

MachineName VARCHAR(10),

GroupName VARCHAR(10)

)

INSERT #MachineGroups (MachineName,GroupName)

SELECT 'Machine1', 'grp1'

UNION ALL

SELECT 'Machine1', 'grp2'

UNION ALL

SELECT 'Machine1', 'grp3'

UNION ALL

SELECT 'Machine2', 'grp1'

UNION ALL

SELECT 'Machine2', 'grp2'

UNION...

Is there a separate table with a list of the machines to check? I ask because you said a machine may have zero groups. Zero groups would mean zero...

I may have misread your original post, are you using package deployment or project deployment model?

If it is project deployment model, your package should be within an SSIS catalog, and...

Out of curiosity, when you run a report on the execution from the catalog, what (if anything) does it say about the script task?

In that case, I'd think doing it online is certainly worth a look. Even if you do it only once a week or less, that's an issue if it...

Not sure what you mean by this. Your cross apply has priorRecord.stock_nbr_ky...