Thank you for the unsolicited advertisement.

Thanks, Matt. I'm outa here. Y'all finish it up in the other thread.

By the way, I have always loved that Descartes joke.

Bob

Hey Jeff, are you going to post your analysis here? If not, please post back to this forum and let us know whether it's an article, another...

Jaggity, can you please show us what your expected output should look like?

PRINT can only print one thing, whether or not it is a string, a variable, or an expression. If you want to attach "FOR XML, etc" to your...

Marianne, I haven't got time to go over the execution plans at the moment, but you may shave a bit of time off by eliminating the update. Try nesting...

... and prevailing wind direction and velocity. Most important. 😉

Time and IO stats would be nice too, please 🙂

Please look at my first message again. You have ORDER_NO in your GROUP_BY clause. The group by clause controls the grouping for which sums will...

It's smart enough. You can test this by displaying the execution plan, then moving a couple of AND statements around in your WHERE clause and seeing if anything...

You ARE summing it by order number... as well as all the other columns you have included in your group by clause.

GROUP BY A.BUSINESS_UNIT , A.ORDER_NO,A.LOAD_ID , A.SHIP_TO_CUST_ID , A.TMS_EXT_REF_ID...

I stand corrected on the behavior of varchar(max) and thank you for the education 🙂

However, it still seems to me that it is a good idea to limit varchar columns...

You're very welcome.

If you have time, please let us know if performance is comparable. I'm sure you can speed it up by making accountID/date...

My solution is much like Seth's except it didn't require altering your base tables to have rowIDs. You can get the job done just by looking for the...

Also, if you have access to SQL Server Management Studio, you can right-click on your db in the object explorer and then select Tasks/Import Data to go to a...