Viewing 15 posts - 3,331 through 3,345 (of 4,081 total)
Hey Fox. Don't be overwhelmed by the rush of answers and questions after each post. There are a lot of people watching and we...
March 18, 2009 at 11:11 am
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......
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...
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. ...
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...
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...
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...
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...
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...
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...
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...
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...
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....
March 17, 2009 at 11:08 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...
March 17, 2009 at 9:49 pm
Viewing 15 posts - 3,331 through 3,345 (of 4,081 total)