Re: Combining Values


If you cant do this in reports, refer this

http://sqljunkies.com/WebLog/amachanic/archive/2004/11/10/5065.aspx?Pending=true

Madhivanan


On Jun 30, 10:47 am, "imani_technology_s...@xxxxxxxxx"
<imani_technology_s...@xxxxxxxxx> wrote:
I wish I could, but this is a data migration. I HAVE to put this
stuff in the table. The customer requires it. More specifically,
Commerce Server requires it.

On Jun 29, 6:55 pm, Ed Murphy <emurph...@xxxxxxxxxxxx> wrote:



imani_technology_s...@xxxxxxxxx wrote:
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?

Do this in the reporting layer (e.g. Crystal Reports) if at
all possible.- Hide quoted text -

- Show quoted text -- Hide quoted text -

- Show quoted text -


.

Relevant Pages

  • Re: Combining Values
    ... The customer requires it. ... Commerce Server requires it. ... John Doe | Address 2 ... Do this in the reporting layer if at ...
    (comp.databases.ms-sqlserver)
  • Re: Snapshot Relational Data into New Tables
    ... > Now consider a simplified version of what a naive schema for a Customer ... > but that isn't telling you any extra information about Mr John Doe. ... > The only situation I can think of is stuff like server and application logs. ... > SQL Server MVP ...
    (microsoft.public.sqlserver.programming)
  • 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)