Viewing 15 posts - 3,736 through 3,750 (of 4,080 total)
In his defense, picking a Ph.D. thesis is not something to be taken lightly. My friends who have gotten degrees have all looked for ideas from their professors...
__________________________________________________
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 13, 2009 at 8:41 am
Sandy,
I don't believe you understood my point. The datatype has nothing to do with it. The problem is that sharing a single address between...
__________________________________________________
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 13, 2009 at 7:30 am
The idea of never updating addresses, but replacing them instead, is a good one. Just make sure you have adequate control over not entering duplicates into the address table.
That's...
__________________________________________________
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 12, 2009 at 2:24 pm
Here's a solution from my recipe file. If you don't already have a tally table, the code to create one is at the bottom. The smiley...
__________________________________________________
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 12, 2009 at 8:26 am
The rest of us have other "important tasks" too, but some people took time out from their day to help you.
I think that your failure to take...
__________________________________________________
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 12, 2009 at 7:51 am
Grant Fritchey (2/12/2009)
I've been trying to stay away from this thread, but here's one:
I tried to help him out with that one Grant. Maybe because it's early and...
__________________________________________________
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 12, 2009 at 7:27 am
I'll take a shot at this one.
---------------------------
First solution:
Since you can't create temporary tables, you create a permanent table with a column to identify each session uniquely....
__________________________________________________
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 12, 2009 at 7:22 am
I've implemented a single address table solution before. One BIG issue that we ran into was changes to addresses (either typographical or just because people move). ...
__________________________________________________
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 11, 2009 at 10:08 pm
Steve, what do you do if they are unwilling, or unable, to take the hints?
Sometimes giving an example in code is the easiest way to illustrate...
__________________________________________________
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 11, 2009 at 2:22 pm
A useful general rule, but not always possible to implement:
* When one of the columns in the candidate key is nullable
* When there is no candidate key (no unique combination...
__________________________________________________
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 11, 2009 at 10:21 am
See my signature line.
__________________________________________________
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 11, 2009 at 10:14 am
I've always done it as a bcp. Build a table that looks like what I want then bcp it out, then create a format file. I'm...
__________________________________________________
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 11, 2009 at 10:12 am
OPENROWSET lets you SELECT from a file as if it were a table. It requires a BCP format file to be associated with it, but essentially you are...
__________________________________________________
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 4:24 pm
I just finished editing an earlier post. Tell me what you think?
__________________________________________________
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 4:16 pm
Bruce:
Yeah, I see the problem. You need a row number or some other unique identifier(s) to tie them together, and if you don't have that in...
__________________________________________________
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:56 pm
Viewing 15 posts - 3,736 through 3,750 (of 4,080 total)