Re: Combining Values

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 -


.

Relevant Pages

  • Re: Combining Values
    ... The customer requires it. ... Commerce Server requires it. ... the client wants. ... John Doe | Address 2 ...
    (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: Snapshot Relational Data into New Tables
    ... storing customer names then apparently you don't need to differentiate ... But why did you store John Doe multiple times? ... The only situation I can think of is stuff like server and application logs. ...
    (microsoft.public.sqlserver.programming)
  • SubReport - Lined Up with Main Report Detail - Repeats any Multivalues??!?!?!
    ... In the main report, I put the customer name and address, and the Order ... John Doe 2/2/2007 ... It lists the three ...
    (microsoft.public.access.reports)