Viewing 15 posts - 43,201 through 43,215 (of 59,063 total)
vick.ram79 (6/26/2009)
select batchID, [outfolder], [outfile]
from (Select batchID, paramName, paramValue From #foo) tmp
Pivot
(Max(paramvalue)
for paramName in (outfolder,...
--Jeff Moden
Change is inevitable... Change for the better is not.
June 26, 2009 at 1:55 pm
I could be wrong but I'd have to say it's because a recursive CTE is just the same as a While Loop (sometimes, it's worse). It's only going to...
--Jeff Moden
Change is inevitable... Change for the better is not.
June 26, 2009 at 1:51 pm
I agree with Lynn. No sign of a triangular join in your query. Are you merely talking about the fact that you have a "derived table" in your...
--Jeff Moden
Change is inevitable... Change for the better is not.
June 26, 2009 at 1:48 pm
Adrienne (6/17/2009)
Can you just add this...,(select sum(b.sal) from cte b where b.seq_no <= a.seq_no and b.deptno = a.deptno) as "RunningTotalWRTDept"
Ummmm.... no. While that works, it has no scalability and...
--Jeff Moden
Change is inevitable... Change for the better is not.
June 26, 2009 at 1:43 pm
Krasavita (6/26/2009)
Thank you:-)
Heh... wait a minute, now.... splitting the date and time is normally a really, really bad thing to do. Why do you need to do this?
--Jeff Moden
Change is inevitable... Change for the better is not.
June 26, 2009 at 12:49 pm
Ah... no joy... I still need some help on this, please. Even though I've found the sp_MS_upd_sysobj_category stored proc in Master and modified the the Web.sql stored procedure that...
--Jeff Moden
Change is inevitable... Change for the better is not.
June 26, 2009 at 12:43 pm
{edit} I still need some help on this because the following didn't work. Please see the 3rd post on this thread. Thanks, folks.
Aw shoot... I guess I'm going...
--Jeff Moden
Change is inevitable... Change for the better is not.
June 26, 2009 at 12:27 pm
Jack Corbett (6/26/2009)
--Jeff Moden
Change is inevitable... Change for the better is not.
June 26, 2009 at 10:25 am
Lynn Pettis (6/26/2009)
I'll have to wait a bit before replying directly as all I can come up with are snide comments about having to earn the right to be funny...
--Jeff Moden
Change is inevitable... Change for the better is not.
June 26, 2009 at 10:20 am
Florian Reischl (6/26/2009)
Noticed the answer and don't really believe it. However - from my side - sometimes saying nothing says all.
I absolutely agree... I hate feeding trolls whether they're malicious...
--Jeff Moden
Change is inevitable... Change for the better is not.
June 26, 2009 at 10:18 am
Sinshith S Anand (6/26/2009)
Hi friends,I am really happy to see Lots of ideas....You can visit my blog also
http://sinshith.wordpress.com/
And let me know your comments...I started writing blog recently
I'd recommend...
--Jeff Moden
Change is inevitable... Change for the better is not.
June 26, 2009 at 10:08 am
Florian Reischl (6/26/2009)
Jeff Moden (6/26/2009)
Florian Reischl (6/26/2009)
Lynn Pettis (6/25/2009)
I only hope he reads the blog, but I doubt it.I hope (s)he did. Next posts have been really okay.
Heh... I'm not...
--Jeff Moden
Change is inevitable... Change for the better is not.
June 26, 2009 at 9:51 am
Sinshith S Anand (6/25/2009)
Still many methods are there.....Please contribute your ideas
Ummmmm... WHY? You writing a book or what?
See ya...
--Jeff Moden
Change is inevitable... Change for the better is not.
June 26, 2009 at 6:24 am
Heh... not to worry, Tom. We've all gotten versions and products confused at one time or another. Thanks for the feedback.
The underlying problem still remains though - cross...
--Jeff Moden
Change is inevitable... Change for the better is not.
June 26, 2009 at 6:17 am
Florian Reischl (6/26/2009)
Lynn Pettis (6/25/2009)
I only hope he reads the blog, but I doubt it.I hope (s)he did. Next posts have been really okay.
Heh... I'm not sure where the link...
--Jeff Moden
Change is inevitable... Change for the better is not.
June 26, 2009 at 6:11 am
Viewing 15 posts - 43,201 through 43,215 (of 59,063 total)