Viewing 15 posts - 481 through 495 (of 702 total)
Flo already gave a great solution with "cross apply", so I won't bother messing about with a CTE that searches out the max() and min() from a UNION of #temp...
May 26, 2009 at 5:11 pm
1. How do you determine the value with which to update FIELD in your #TEMP? Is it supposed to be from the #TEMP1 row that has the min(DATEIN) or...
May 26, 2009 at 1:13 pm
Steve Jones - Editor (5/26/2009)
May 26, 2009 at 11:46 am
I just shook my head at how even the "I got it solved" post seems to indicate lack of understanding.
I already solved the problem by using SSMS or Import/export...
May 26, 2009 at 11:44 am
GSquared (5/26/2009)
I've actually seen this before. Don't remember where, but we came to the same conclusion that it's a whitespace parsing thing.Would make a good QotD submission, Grant.
I submitted...
May 26, 2009 at 9:37 am
Jan Van der Eecken (5/22/2009)
Lynn Pettis (5/22/2009)
May 22, 2009 at 3:30 pm
Luke L (5/22/2009)[hr.... I enjoy chasing after a small white ball err.. golfing however watching it on TV is like watching paint dry. Same with baseball, basketball, etc. ...
May 22, 2009 at 12:34 pm
Christopher Stobbs (5/22/2009)
May 22, 2009 at 10:40 am
Years ago, I remember going to classes on "structured walkthoughs" in which we were taught to embrace "egoless" programming. Walkthroughs of designs or code were to be conducted by...
May 22, 2009 at 10:00 am
My name is John and I'm a threadaholic.....
I have to share this with folks who will understand. I believe I will be dreaming tonight of warrior women hurling ninja...
May 21, 2009 at 8:36 pm
I don't have the old QM anymore, but in my SQL2005 SSMS connected to a SQL2000 engine gives the same behavior, including the interpretation of "E"xponent notation. Interesting stuff...
May 21, 2009 at 12:23 am
Bruce, I like your solution better, if only for readability, as it keeps all the join criteria together. My suggestion may work OK, but by the time all the...
May 20, 2009 at 11:37 pm
Rather than think procedurally, which is only natural when you see what could be considered a recursive structure, another approach may be a fairly straight-forward use of self-joins. This is...
May 20, 2009 at 7:29 pm
I think you've made it more complicated than necessary. The HAVING option on GROUP BY should do the trick for you without the self-join.select ApplicantID,
...
May 20, 2009 at 6:00 pm
Would not an OUTER join solution work too?Select *
from Table_A A
left outer Join Table_B B on B.col_1 = A.col_1
left outer Join Table_C C on...
May 20, 2009 at 5:37 pm
Viewing 15 posts - 481 through 495 (of 702 total)