Viewing 15 posts - 7,831 through 7,845 (of 9,713 total)
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
So many potential solutions. I like Steve's solution stuffed in a sub-query and broken out into separate columns. Then just do a count in the outer query and group by...
July 12, 2010 at 11:19 am
Alan G-436699 (7/12/2010)
As my loop is generic code, I really don't want to define a column list (I am copying 600 tables).
Column List in the SELECT part of the...
July 12, 2010 at 11:09 am
Do a search on phrase "Dynamic Pivot". See if that helps you out. Then post back on this thread with further questions about it.
July 12, 2010 at 11:05 am
Glad I could help. Let me know if you have any more questions regarding this issue.
July 12, 2010 at 5:47 am
Well that depends on where the .exe file is located. If it's on a UNC or Share drive, you just need to add the proxy account to that path's Security...
July 12, 2010 at 5:43 am
Viewing 15 posts - 7,831 through 7,845 (of 9,713 total)