Viewing 15 posts - 2,926 through 2,940 (of 4,080 total)
Lynn: Wait... are we disagreeing about something?
If so, don't mind us, Scott. Sidebar discussions are the only payment a volunteer ever gets.
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
April 27, 2009 at 2:14 pm
Ewww....
Did the same people who wrote the first chunk of code design your DB ??
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
April 27, 2009 at 1:45 pm
I provided the trivial data, but mine still works if they aren't in sequence. That was omitted from the original specs, so I didn't want to assume...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
April 27, 2009 at 1:43 pm
Lynn, doesn't this assume that all the duplicates are going to fall together in sequence?
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
April 27, 2009 at 1:02 pm
Looking at the two little schema you supplied, I don't understand why the user ID is associated with a piece of equipment, rather than with skills. I would...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
April 27, 2009 at 12:52 pm
Tsk... I'll never understand what is wrong with a simple integer.
cast(min(cast(ID as varchar(50))) as uniqueidentifier)
I can give you a cross apply solution, but nothing will build #dupRawData as...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
April 27, 2009 at 12:40 pm
Scott, please note that I revised my original solution to cut down on the number of scans of your input table. It now creates a temp 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
April 27, 2009 at 12:02 pm
This should work for you. I just revised this to break duplicate RawData into a separate temp table and index it. The original version using just...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
April 27, 2009 at 11:25 am
Why so it is! Sorry. Good luck with implementing the Calendar table. You won't regret 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
April 27, 2009 at 8:38 am
Thank you SO much for posting up sample data. 🙂
I'm still not sure I completely understand your requirements. Can you add to your post what you would...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
April 27, 2009 at 6:06 am
Been there, Barry. You get LOTs of sympathy and well-wishes. The good news is that it will all be over quickly. I mean that...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
April 26, 2009 at 6:44 pm
Morning, Alvin 🙂
NEVER type while NOT caffeinated!!
Isn't that what I said? Must... drink... more ... coffee....
Isn't it beautiful outside this weekend? ...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
April 26, 2009 at 9:06 am
The rows column would be the same.
Do you think if I went back and edited my post to remove the code, the Thread might forgive me?
And... my assumption about 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
April 26, 2009 at 8:46 am
I've done it many times.... and yes it is 😀
Mostly I've had to explain to someone why I favor running many reports against summary tables that are populated with totals...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
April 26, 2009 at 8:35 am
Okay, so I'm still catching up on this thread, and this quote is from mid-Feb.
Wayne:
You need to admit that you need help.
I'd like to invite...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
April 26, 2009 at 8:19 am
Viewing 15 posts - 2,926 through 2,940 (of 4,080 total)