Viewing 15 posts - 4,021 through 4,035 (of 4,080 total)
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
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
October 16, 2008 at 9:08 pm
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...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
October 16, 2008 at 8:02 pm
Jaggity, can you please show us what your expected output should look like?
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
October 16, 2008 at 7:47 pm
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...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
October 16, 2008 at 7:37 pm
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...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
October 16, 2008 at 2:33 pm
... and prevailing wind direction and velocity. Most important. 😉
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
October 16, 2008 at 1:39 pm
Time and IO stats would be nice too, please 🙂
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
October 16, 2008 at 9:58 am
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...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
October 16, 2008 at 9:55 am
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...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
October 16, 2008 at 7:38 am
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...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
October 16, 2008 at 7:31 am
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...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
October 15, 2008 at 4:47 pm
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...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
October 15, 2008 at 3:40 pm
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...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
October 15, 2008 at 1:34 pm
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...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
October 15, 2008 at 11:28 am
You can use the BCP utility to execute a query and direct the output to a data file on disk.
To launch BCP from within a stored procedure, build the BCP...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
October 15, 2008 at 11:20 am
Viewing 15 posts - 4,021 through 4,035 (of 4,080 total)