Viewing 15 posts - 1,276 through 1,290 (of 4,080 total)
Paul, I think you missed something in the midgame posts. His question is really why it didn't throw a syntax error when he used = to compare...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
October 13, 2010 at 7:29 am
Revised modest proposal: Carry katana and wakazashi on your person at all times.
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
October 12, 2010 at 1:48 pm
Respectfully, it wasn't clear. I read it the same way sturner did at first.
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
October 12, 2010 at 1:43 pm
Alvin Ramard (10/12/2010)
The Dixie Flatline (10/12/2010)
Just lay them on the table...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
October 12, 2010 at 1:39 pm
Modest proposal for you, Gail: Take your katana and wakazashi to the next meeting.
Just lay them on the table and proceed to discuss things...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
October 12, 2010 at 1:31 pm
Not after you groaned at my joke.
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
October 12, 2010 at 1:27 pm
This is an American joke I just had to add here. You both deserve time off for GUID behavior.
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
October 12, 2010 at 11:02 am
It not only reads easier, it should be child's play to generate dynamically as well.
Jeff, you should check out this thread. It's about a year old, but it...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
October 11, 2010 at 8:12 am
Whatever the percentages, all you guys (and gals) are awesome.
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
October 10, 2010 at 12:36 pm
One alternative is the old school way: Do a summary query.
GROUP BY all the columns used to determine a duplicate . Store all results...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
October 9, 2010 at 7:55 pm
If I correctly understand what you are trying to do, the attached dynamic SQL code would do the trick for you. But I'm not sure this is...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
October 7, 2010 at 5:36 pm
I just had an idea for an epic summer movie. It involves an intrepid group of DBA's and SQL Developers who get sent back to prehistoric...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
October 7, 2010 at 4:03 pm
Alvin Ramard (10/7/2010)
The Dixie Flatline (10/7/2010)
Thanks to everyone for sharing your knowledge, insight, humor, and support.When you say humor, are you including me? 😀
Alvin, I couldn't exclude 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
October 7, 2010 at 3:59 pm
Thanks to everyone for sharing your knowledge, insight, humor, and support.
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
October 7, 2010 at 3:29 pm
You seem to be trying to turn columns into rows. Will one of the solutions below work for you?
declare @sample table ([product_id_1] int,
[scan_time__sec] int,
[focal_spot_mm] int,...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
October 7, 2010 at 3:19 pm
Viewing 15 posts - 1,276 through 1,290 (of 4,080 total)