Viewing 15 posts - 55,516 through 55,530 (of 59,078 total)
First and foremost, Serqiy is correct... delimited data should not be allowed to be stored in the database. The inserts to the database should be done via a staging table,...
August 5, 2007 at 1:08 pm
Boy, I'll say... dunno why I made the dupe check separate...
must've been that old donut I ate this morning
August 4, 2007 at 5:44 pm
Wonder why Seric thought that technique required knowing what the words are? ![]()
August 4, 2007 at 5:29 pm
It's ok... that's why all the smiley faces...
you're doing the right thing... when you have a front end involved, let it do...
August 4, 2007 at 5:26 pm
Heh... the reason why you didn't find it in Books Online is because formatting dates for a GUI in SQL is a really bad idea for about a thousand reasons,...
August 4, 2007 at 2:32 pm
Ok... let's say that's correct for a minute... what does something like the following cost in the short term? Nothing... schedule met... everyone was happy...
What's it costing them now? Somebody was...
August 4, 2007 at 10:15 am
Well kinda...
Change the FK's to "CASCADE ON DELETE" and then you only need to delete from one table ![]()
Lookup "cascading referential integrity constraints" in...
August 4, 2007 at 10:11 am
P.S. If you do decide to go the temp table route as I suggested, then adding the appropriate indexes and a primary key on the temp table may help speed things...
August 4, 2007 at 10:06 am
Rom Beng,
Something like this should do it for you... read the embedded comments for an explanation, please... I did not use your given table structures... this is all based on...
August 4, 2007 at 9:42 am
What was the question???? And, if you solved it, what was the answer???
August 3, 2007 at 8:26 pm
You bet... thank you for the feedback.
August 3, 2007 at 8:01 pm
Viewing 15 posts - 55,516 through 55,530 (of 59,078 total)