Viewing 15 posts - 3,751 through 3,765 (of 4,080 total)
Bruce, check out the OUTPUT clause to an INSERT. You can trap ALL the recently generated IDs from the mass INSERT, not just the last one, into...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
February 10, 2009 at 3:08 pm
1. Bruce is absolutely right. If possible, rethink this whole idea of writing the code on the fly in your UI. That approach will...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
February 10, 2009 at 3:02 pm
You're very welcome. I just hope they are the right cust_ids 😉
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
February 10, 2009 at 2:35 pm
GSquared (2/10/2009)
To add to what Bob wrote, harming the organization harms their customers and employees as well.
Absolutely! I've never had a problem seeing the harm to 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
February 10, 2009 at 1:43 pm
Not only that Roy, but I've seen questions on here that read something like this:
"I've just deleted some huge, important tables and I haven't been doing backups. How...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
February 10, 2009 at 1:07 pm
leslaw (2/10/2009)
All tables should have primary key, so it should also be created.Leslaw
Cardinal Moden will call me a heretic, yet I beg to differ with respect to the word "ALL"....
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
February 10, 2009 at 12:49 pm
Bruce, I would guess not, since noeld asked that question earlier. But the question bears repeating.
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
February 10, 2009 at 12:35 pm
Looks good to me, if it looks good to you. 😀
The tally table was totally unnecessary to the solution, but I included the article reference in case anyone...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
February 10, 2009 at 12:23 pm
I started out in Hugo's camp. I'm always glad to have learned a new function, but one thing I can't get away from is that, in 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
February 10, 2009 at 12:17 pm
This is why I think interview questions should just go unanswered, even deleted. There's no telling how much damage is done to companies that are foolish enough...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
February 10, 2009 at 11:32 am
Milan... I don't see a UNION ALL.
It doesn't matter if all the lines are being generated by the user interface at one time or not,...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
February 10, 2009 at 10:52 am
So are we ever going to see the mysterious INSERT statement or not? 😉
I'll read the article, but the fact remains 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
February 10, 2009 at 10:24 am
Yes it can.
This solution doesn't involve a tally table, I just used it to set up the test data. But if you don't have one look...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
February 10, 2009 at 10:13 am
I don't see anything odd about your schema at first glance.
Do you have indexes on the columns used as foreign keys?
Does the asp.net code generate an INSERT statement for each...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
February 10, 2009 at 9:37 am
I may have to try some of those on Joseph (*URGENT*URGENT*URGENT*) Tran.
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
February 9, 2009 at 1:03 pm
Viewing 15 posts - 3,751 through 3,765 (of 4,080 total)