Winston, I don't know a way to do that in Visual Studio, but if you are allowed to modify the proc, then try adding a @debugMode parameter to it. ...

Thank you for taking the time to explain.

Good job, Flo 🙂

Thanks, Luis.

Sorry to say this, but those CREATE TABLE statements don't seem to work with your INSERT statements. I keep getting an error saying column names are invalid. ...

Luis, can you also send the CREATE TABLE statements for FN and FO??

Great 🙂

Thanks for taking the time to let us know.

Beautiful 🙂

While I'm looking at this, have you checked out the link I pointed you to in the first message? I expect to use the same CROSS APPLY...

Shannon, could you please post up the query and subquery so that we have some idea of what you are attempting. You may have to do a workaround...

I have to ask why you are using different tables.

You can certainly join any of those tables that have common ID to get a first name/last name pair,...

Let me interrupt to drag the conversation away from futbol.

Lynn!! Lynn!! I actually had someone say they had an "ah-hah" moment... with respect to setting up test...

Great 🙂 We'll look forward to hearing from you.

Luis, I will be happy to help you. I just answered a similar question here. Let me know if you understand how it could...

Dang, you're fast, FLO !!!

When I get a chance, I'll crank out a large test set and we can race our solutions, or perhaps they could both be tested against...

Here you go. I did not take the time to do the date conversion to the format you had in your output sample, but I'm sure you...

Can do. It will take a few minutes to set up. In the meanwhile, will you please have a look at this link? ...

I hear you, Lynn.

That thread reads like " I want the problem to be with the SQL Server. Tell me how to fix it....