Thanks G-Squared.

What I ended up doing was created a stored procedure that first select all distinct uids from the invoice table ordered by invoice number. Since invoice numbers increment...

Ok so I know how to do this now.

I use a stored procedure to get all distinct customers while ordering by their associated invoice.date.

I store this information in a declaration...

I think I need to do the following logic:

SELECT *

FROM customers INNER JOIN

invoices INNER JOIN

tickets

WHERE top 1(invoice sorted ascending...

This is actually for a client needing an export of unwanted customers. I wanted to see how theoretically this could be accomplished.

Also, How is you telling me the...

It returns the record, yet when i run my app the dataset is null (until I remove the update).

I ended up creating a separate query for the update and rearranged by asp.net code to work with it. My beliefs about this, until someone changes it, is that...

After changing the declared table to a temporary table I am still not getting any results in my asp.net dataset. This makes no sense. If the temporary or...

worked like magic! The query now only takes 6 seconds compared to 1:30.

Thanks a ton!!

Cheers,

Justin

Hey guys I am back. I have another query that I am optimizing that is very similar to the one in this post a couple of months back.

Here is...

That is insane... I have much to learn and it looks like I'm at the right place! 😎

3 seconds with correct results! 😀

Antares

Your query did get the correct values, however it took 55 seconds to run the query. I think that the previous solution of using the exists rather than the...

wow.. I'm learning more and more.. I'll let you know if that last one work as well. Thanks!

Ken: I just tried your suggestion and after adding the brackets around the bottom in Gray, it worked beautifully. It got all 4 of the accounts in...

Interesting Ken. Thanks for that info as well. I will try your query out and get back to you on that as well.

I am still a...