Dwain, thanks for the article. It's about creating histograms using SQL, which is exactly what I am trying to do ...

I needed quotes around new values

, CASE

WHEN DATEDIFF(minute,CAST([ActualStartTime]+ GETDATE() - GETUTCDATE() as DATE),[ActualStartTime]+ GETDATE() -...

sounds good.

can you see what's wrong with the CASE statement?

, CASE

WHEN DATEDIFF(minute,CAST([ActualStartTime]+ GETDATE() -...

Very nice of you Sean.

Aliased the table variable, and referenced the values in the table variable with column name.

worked:

DECLARE @benches TABLE (Bench varchar(20));

INSERT @benches

values

('LabC1'),

('LabC2'),

('LabC3'),

('LabC4');

INSERT INTO RunsByBench

SELECT

Bench as...

before I go there, I want to clarify. The parameter @benches is called out in the left query as well as the right.

I tried this:

created tvf

CREATE FUNCTION...

is it possible to put the right side of the OUTER APPLY into a TVF, given that the input values are coming from an array type variable?

to be honest, I did, but I'm not going to battle that anymore. As long as commenting out the With Schemabinding allows me to continue with the APPLY 'lesson' I'm...

well, then I had to comment out WITH SCHEMABINDING, because try as I might, to do what the message wanted, it was still same error.

If you can show me...

I'm trying to apply what I've learned in the APPLY links you left me, Luis, to my solution. Thus, I want a TVF for the right half of the query....

Excellent, thanks again.

The whole point is to improve performance so I really appreciate added notes about table variables versus temp etc. APPLY articles were great.

for some reason the first time I used #temp table with query it didn't work. Forget the error.

Now either #temp or table variable works.

So, I'll post the entire...

Yes, I jumped to thank you but I am examining it. I agree, I must understand so I can reuse in other situations.

I may have some more questions about...

This worked, Thank you Luis.

Thank you Matt!

That's very appreciated. You saw the mistake in my own set operation which should have been (and I thought it was) just like the practice test query.

SELECT color

...