Viewing 15 posts - 7,831 through 7,845 (of 9,715 total)
lionwelp (7/26/2010)
They are both in the same record
Okay, this goes back to my second to last post. Will the data ALWAYS be that way?
If not, you're out of luck. You...
July 26, 2010 at 12:08 pm
Hey, now! "Size matters not!"
...I've seen bigger anyway. @=)
July 26, 2010 at 12:01 pm
lionwelp (7/26/2010)
July 26, 2010 at 8:10 am
Jeff Moden (7/24/2010)
Steve Jones - Editor (7/23/2010)
Speedo under the black ghost cloak...GAH!!!! Now I have to jab out my mind's-eye!
Here, Jeff! Grab this bottle of Brain Bleach!
The pain will...
July 26, 2010 at 7:43 am
David O (7/9/2010)
BTW, first this I should learn about Teradata is how to spell it correctly.
Nah. Not knowing how to spell the product will get your resume in the doors...
July 26, 2010 at 7:40 am
...and AGAIN...
I wrote a chapter for Tied In: The Business, History and Craft of Media Tie-In Writing.
It's currently available in ePub versions and Kindle (see .sig for links).
Soon to...
July 26, 2010 at 7:36 am
Glad I could help. Let me know if you have any other questions on this subject.
July 21, 2010 at 8:46 am
xanthos (9/1/2008)
The substring functio should be:SUBSTRING(name,1,2) = "ab"
Actually, the substring function should be SUBSTRING(name,1,2) == "ab".
If you use a single = sign, SSIS assumes you are assigning a value to...
July 21, 2010 at 6:58 am
Chris Morris-439714 (7/16/2010)
Eugene Elutin (6/30/2010)
Actually, recursive CTE is not far from RBAR (can be even worse in performance)...
Not strictly true. A good example of RBAR would be performing a running...
July 16, 2010 at 8:06 am
Just an FYI:
Earlier, I was seeing 3 duplicate numbers when running your original NewID() solution. Repeated runnings seems to generate between 0 - 5 duplicate numbers with no discernible pattern...
July 16, 2010 at 6:54 am
Eugene Elutin (7/12/2010)
Sorry, but your real issue is not reading answers carefully and not trying to run given samples of code.
And perhaps you should test your own code too?
Yes, I...
July 16, 2010 at 5:38 am
Ah. Yes. Pivot does require aggregation. Sorry. I didn't realize that's what you're doing.
Hmm. Now I'm wondering if there's a way to trick Pivot into doing an aggregation that isn't...
July 12, 2010 at 11:32 am
Bleargh. I had a feeling that was going to be the answer.
Oh, well. If I hadn't asked the question, there would have been an alternative. @=)
Thanks, Gail.
July 12, 2010 at 11:25 am
Viewing 15 posts - 7,831 through 7,845 (of 9,715 total)