Viewing 15 posts - 3,331 through 3,345 (of 4,080 total)
Okay... so the user decides the sequence. If he says the sequence number is a 2 and there is already a sequence 2 in the existing 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
March 18, 2009 at 11:00 am
Continuing my previous example with your data. I get the results desired by simply ignoring the sequence number column. If I'm going to do this...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
March 18, 2009 at 10:57 am
After inserting part in the table we need to resequence the sequence number which depends on the partnumber
'
Fox, I will write a little bit of code to do 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
March 18, 2009 at 10:45 am
Fox, I can't speak to Oracle. I'm totally ignorant there, although I'm told they code totally differently. I will say that, in SQL Server, solid set-based...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
March 18, 2009 at 10:25 am
Semicolons mark the end of an SQL statement... while they are not currently required, I've heard rumors that they will be in the future You can leave...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
March 18, 2009 at 10:05 am
I hear you, J.
But when you've only been taught one way, you build an entire conceptual model around it. It takes time to unlearn 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
March 18, 2009 at 9:38 am
Wow, I type this in and see the latest post. That was a good thing, Fox. I'm not being patronizing when I say...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
March 18, 2009 at 9:30 am
Understood, Lynn.
Fox, I do agree that you were out of line calling Lynn dense. He's a pretty bright guy who has helped a LOT of...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
March 18, 2009 at 9:27 am
Now, back to business. Foxjazz is on the edge of enlightenment. I think we should cut the man some slack, because he has dropped the insults...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
March 18, 2009 at 8:43 am
Kevin:
Changes do get made and for the better. Constructive suggestions eventually get heard. I was really happy to see try/catch logic emerge, and CTEs, and inline...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
March 18, 2009 at 8:35 am
So what do you think, Lynn? Is our man trying to learn something now? He seems to be refraining from insults, and he's actually providing...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
March 17, 2009 at 11:14 pm
This can easily be done with a setbase solution????????????
Yes it can, Fox. 🙂 Don't be amazed. We do this for a living....
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
March 17, 2009 at 11:08 pm
I'm not a number!! I'm a free man!!
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
March 17, 2009 at 9:55 pm
Understood, Azeem. I just wanted to make sure we didn't unleash a beast that was going to return 300 columns on a single row. Dynamic SQL...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
March 17, 2009 at 9:49 pm
Say it ain't so, Bruce !!! :w00t:
I can't code tonight but my brain is still functioning and I have an idea. Why not use a tally 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
March 17, 2009 at 9:46 pm
Viewing 15 posts - 3,331 through 3,345 (of 4,080 total)