Group by OrderID and put in a HAVING clause where you check that the MAX value of Status is Shipped, and the MIN value of Status is Shipped.

John

OK< a few generalisations.  A clustered index usually works best on a narrow key (int, for example), and for a column that is monotonically ascending column (a timestamp or identity,...

Yes, you can certainly use a trigger, or you can periodically query the table for the data and invoke the job when it arrives.

John

How does the vendor-managed application run the reports?  Does it issue stored procedure calls, or does it build ad hoc SQL and execute that?  You may have an issue with...

Which part of this are you having trouble with - inserting into orders from the two tables jobs and SiteAddresses in a single statement, or inserting into the two tables...

Maybe this thread will help you?

John

Pay attention,  I never mentioned the transaction log.  And just because people scream, or write in capitals, it doesn't mean they're right.   There's absolutely nothing wrong with shrinking as a...

You might want to try a different search engine!  There's plenty of information out there.  Here's what you need to do.

John

No, you can't use a table variable as an output parameter.  What you can do, though, is have the stored procedure return a result set, insert that into a table...

1. Check how you've spelt "description" in your list_erreur table
2. Remove the description_erreur column from the rest of your tables
3. Create a foreign key constraint between the id_erreur column in...

Be advised that if you cannot guarantee that the individual files are guaranteed to go to separate physical spindles (if you're backing up to spinning rust), striped backups can...

You mean a striped backup?  No, they don't have to go to different paths.  Depending on your disk configuration, though, your backup may run faster if they do.

John

One very good reason to use a domain account instead of the default account is to get access to network resources so that you can, for example, back up your...

You'd be better off posting in a MySQL forum - this one is for SQL Server.  You're probably right - you'll need a recursive solution.  Wherever you seek help, I...

OK, so the requirement has changed a little.  You now need to concatenate the values into a string rather than having each as a separate column in the same row. ...