Viewing 15 posts - 3,046 through 3,060 (of 4,080 total)
Hey Jack:
I think we're on the same page. I would never advocate that front-end editing be abandoned in favor of ONLY bouncing errors back from the server, but...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
April 16, 2009 at 2:04 pm
1. You're posting it into Excel? Why not just do the running total's there? It takes about two seconds!!
2. Although cross-apply works,...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
April 16, 2009 at 10:11 am
To find similar threads where this question has been discussed, search SSC on the following keywords:
PIVOT
CROSSTAB
You do need to know the values you are going to turn into...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
April 16, 2009 at 9:36 am
I know of no technique that can produce running totals without using a temporary table. Essentially, you do an update assigning a variable value to a column to...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
April 16, 2009 at 9:31 am
I'm right there with you, Gus.
By the way, Grant, you made a typo... it's "Night of the Living Thread."
Oh yeah... and "Shawn of the Thread." Hilarious. Made...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
April 16, 2009 at 8:59 am
PorkChopMan vs. the Son of the Bride of the Thread?
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
April 16, 2009 at 8:20 am
How could I have forgotten "Bride of the Thread?"
I LOVED Kate Beckinsale in the last remake. 😛
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
April 16, 2009 at 8:09 am
if the THREAD starts to approach 5000 posts, I'm going to hunt it down & kill it
Somewhen in the robotic apocalyptic future they are assembling a Threadinator with...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
April 16, 2009 at 8:04 am
This is like following a chain of B-Movie horror films...
First there was.... "The Thread".
Then came the "The Son of Thread".
Future Titles
The Other Thread
Revenge of The Thread
Return of the Son of...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
April 16, 2009 at 8:00 am
Do you mind posting the link to this thread. I must have missed it.
Here you go. Flo stirred up quite a debate by identifying a situation where...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
April 16, 2009 at 7:45 am
Somehow users managed to input some of the customer order numbers as lower case
Looks like they tried and failed, Jack. The counter-argument would be that if that...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
April 16, 2009 at 7:42 am
Do you have SQL Server Management Studio? If so, use the Object Explorer to drill down to the indexes on your table, then right-click on the index you...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
April 16, 2009 at 7:24 am
Barry, ASCII stands for American Standard Code for Information Interchange. It was a standard promulgated by the American Standards Association, which was a predecessor organization to ANSI.
See Wikipedia.
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
April 16, 2009 at 7:06 am
You're welcome, Ron. Hope we didn't overwhelm you with detail. 😉
These sidebar discussions often go into way more minutiae than is required...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
April 16, 2009 at 6:55 am
If I'm not mistaken, ASCII and Unicode are both ANSI standards, but I didn't want to add that level of complexity to the explanation.
EBCDIC !!!
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
April 16, 2009 at 6:49 am
Viewing 15 posts - 3,046 through 3,060 (of 4,080 total)