Posted by haslam007 on 01/18/07 17:10

How would i do this in Crystal?


Ed Murphy wrote:
> parth wrote:
>
> > I want to achieve the following transformation of data using a stored
> > procedure.
> >
> >
> > Source
> >
> > col1 col2(varchar)
> > -------------------------
> > 1 1.1
> > 1 1.2
> > 2 2.1
> > 2 2.2
> > 2 2.3
> > =================
> >
> > Desired Result
> >
> > col1 col2(varchar)
> > --------------------------
> > 1 1.1 | 1.2
> > 2 2.1 | 2.2 | 2.3
> > =====================
>
> Eww. Are you sure you can't do this in the application layer? (It
> would be simple in Crystal Reports, for instance.)

• Next in forum: Query which calculates a field value based on previous row's values
• Prev in forum: Datawarehousing/Business Intelligence Training Class
• Thread view: Re: stored procedure to concatenate column value sin a single cell?

[Reply to this message]