Viewing 15 posts - 8,791 through 8,805 (of 10,144 total)
Is there a maximum number of dots?
February 17, 2009 at 3:54 am
Paula (2/16/2009)
February 16, 2009 at 9:37 am
You might not be making any mistakes at all, depending on what you reply to Ninja. The UPDATE looks a lot simpler written as a straightforward UPDATE...FROM though, particularly if...
February 16, 2009 at 9:25 am
Experiment, Mike. Since you're using IN () in the second query, you don't need DISTINCT in the first unless it's to dramatically reduce the rowcount because you're feeding into a...
February 13, 2009 at 2:17 pm
Lynn Pettis (2/13/2009)
... and one of them I got down here where I work now. If I could get the other one, in a heartbeat.
Heh yeah I know what...
February 13, 2009 at 9:36 am
Lynn Pettis (2/13/2009)
February 13, 2009 at 9:16 am
Roy Ernest (2/13/2009)
It will look bloody good on the resume....:hehe:
Funny you should say that...it's been said that you should study for a PhD for yourself, not for anyone else -...
February 13, 2009 at 9:04 am
Mike Levan (2/13/2009)
what is the work around for this so the it never happens again.
B****slap your network engineer, tell them not to let it happen again or there will be...
February 13, 2009 at 8:44 am
GilaMonster (2/13/2009)
Chris Morris (2/13/2009)
February 13, 2009 at 8:28 am
Mike Levan (2/13/2009)
"A transport-level error has occurred when sending the request to the...
February 13, 2009 at 8:21 am
Michael Earl (2/13/2009)
Roy Ernest (2/13/2009)
Allright... Thanks for the explanation..Did you see this question?? :ermm:
Don't you regularly export relational database systems to an Excel file?
All the time. Why restrict yourself to...
February 13, 2009 at 6:55 am
Mike Levan (2/13/2009)
ChrisI dont see any diffrence in your query when compared to mine. Its just the same, then how would that improve performance?
There's no difference at all, Mike, just...
February 13, 2009 at 6:49 am
Roy Ernest (2/13/2009)
Chris Morris (2/13/2009)
Jeff Moden (2/12/2009)
Heh... nope... that's my ol' "buddy"... and those are typical questions from him.
This poster's been active for a couple of years...quite a few of...
February 13, 2009 at 6:38 am
Hi Mike
Can you put all the table aliases into the first query please?
select distinct a.RevID
into #Rev
from vwBud as a inner join dbo.datesJi as b
on a.RevID=b.RevID
where (JoinDt between '12/4/2001'...
February 13, 2009 at 6:05 am
Jeff Moden (2/12/2009)
Heh... nope... that's my ol' "buddy"... and those are typical questions from him.
This poster's been active for a couple of years...quite a few of his posts might make...
February 13, 2009 at 1:05 am
Viewing 15 posts - 8,791 through 8,805 (of 10,144 total)