Combining Values
I need to do something that goes against normalization, but it is what
the client wants. Let's say one person has several addresses. I need
to be able to take each of those addresses and combine them into one
field. So I need to take this:
John Doe | Address 1
John Doe | Address 2
John Doe | Address 3
And combine them into this:
John Doe | Address 1; Address 2; Address 3
Do I need a cursor for this?
.
Relevant Pages
- Re: Database design help.
... <Client Data Fields That Never Change> ... name is john doe, a note is done and saved, now 3 months ... later client comes in and name is john smith. ...
(microsoft.public.access.tablesdbdesign) - Re: Digital signatures
... If another person decide they're going to claim their John Doe, ... That's how every co-operative mail/PGP client I've used works. ... It'd take a war of words between the two people in a common forum for ... A printer configuration backend/frontend combination. ...
(Fedora) - Re: Data Normalization
... John Doe ... one column in a 10 column invoices table that tracks the name of the ... client and that is the only aspect of the client that you track, ... John Doe is not the same on all records. ...
(microsoft.public.access.gettingstarted) - Re: Mail relay question
... You could be the client of 3 ISP's at 3 different locations, using 3 different outgoing SMTP servers, and still use the same email address. ... read the SMTP RFC or google for simple examples / resources. ... my thought was that my wife will trust anything sent to her as ... So unless they know exactly what name you set (John Doe, Doe, John, JDoe, Johnny, etc), your wife will notice the difference from the previous emails and should get suspicious. ...
(Security-Basics) - Re: Database design help.
... <Client Data Fields That Never Change> ... name is john doe, a note is done and saved, now 3 months ... later client comes in and name is john smith. ...
(microsoft.public.access.tablesdbdesign) |
|
