Viewing 15 posts - 3,736 through 3,750 (of 4,081 total)
I just looked at this post again and realized I need to revise my recipe. There is really no need for a table variable here, a cte is...
February 15, 2009 at 10:15 am
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...
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...
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...
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...
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...
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...
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....
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). ...
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...
February 11, 2009 at 2:22 pm
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...
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...
February 10, 2009 at 4:24 pm
I just finished editing an earlier post. Tell me what you think?
February 10, 2009 at 4:16 pm
Viewing 15 posts - 3,736 through 3,750 (of 4,081 total)