Viewing 15 posts - 646 through 660 (of 4,080 total)
Patience
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
June 24, 2013 at 5:07 pm
omniscient
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
June 24, 2013 at 3:47 pm
GilaMonster (6/24/2013)
You shrunk a database? How could you???:hehe:
Yeah, they told me at PASS that every time you shrink a database a puppy gets killed. :crying:
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
June 24, 2013 at 3:44 pm
For best performance with a MERGE, its a good idea to have both source and target tables indexed on the columns used to determine a MATCH. Other suggestions...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
June 21, 2013 at 9:58 pm
Here is an illustration of what I think you're talking about. If my assumptions are wrong, please change the code up to illustrate generally what your tables...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
June 21, 2013 at 9:46 am
To be sure you get a coded and tested solution, it would help if you could post up some sample data and an expected result set. The people...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
June 21, 2013 at 9:03 am
opc.three (6/20/2013)
Voight
Nulland
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
June 20, 2013 at 3:53 pm
crookj (6/20/2013)
Cliff Jones (6/20/2013)
sing4you (6/20/2013)
MargaritaTequila
Sunrise
Salt
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
June 20, 2013 at 2:23 pm
SQLRNNR (6/20/2013)
Grant Fritchey (6/20/2013)
WayneS (6/19/2013)
GilaMonster (6/19/2013)
Please tell me I'm reading that last post from the OP wrong.http://www.sqlservercentral.com/Forums/Topic1464172-391-1.aspx
Wow...
+Infinity
* infinity
(making sounds of head exploding)
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
June 20, 2013 at 10:16 am
Sorry if I misunderstood. I would like to add my thanks for your taking time to post the problem with sample data.
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
June 20, 2013 at 7:54 am
Daniel Bowlin (6/20/2013)
SQLRNNR (6/18/2013)
JAZZ Master (6/18/2013)
Daniel Bowlin (6/18/2013)
The Dixie Flatline (6/18/2013)
t-bonedOuch!!
Insurance Hike
Insurance Drop
Lemon drop
Gummy bear
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
June 20, 2013 at 7:50 am
I never knew you were descended from mercenaries.
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
June 19, 2013 at 2:40 pm
GilaMonster (6/19/2013)
Please tell me I'm reading that last post from the OP wrong.http://www.sqlservercentral.com/Forums/Topic1464172-391-1.aspx
Yeah. No good can come from that situation unless he confesses to his client that the...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
June 19, 2013 at 8:20 am
I am going to add one more wrinkle... initials. Bill Smith may actually be J. W. Smith, but the logic you are talking about would eliminate...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
June 19, 2013 at 8:16 am
If I understood you correctly, your problem isn't really how to group by a date: GROUP BY [ASSIGNED] takes care of that. I'm sure you...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
June 19, 2013 at 7:35 am
Viewing 15 posts - 646 through 660 (of 4,080 total)