Skip to Content
0
Former Member
Dec 23, 2009 at 07:34 PM

Concatenating within SQL Command

11 Views

Hello,

I need to do the following concatenation in SQL and add it into Command. I know how to do it in Crystal using subreports and shared variables using runtime concatenations, when I export it into Excel, the data returned in excel is not aligned properly.

I'd like to ask you guys for assistance on how I can do the following in SQL:

The data looks as follows:

check#      check_line     desc_line        des
12233          100                 1        Joe Smith Trip to Vegas
12233          200                 1        Cab pickup @ 5:45pm to Palms  wait
12233          200                 2        time 12 minutes.
12233          300                 1        Meals
12233          400                 1        Dinner w/ Jane Doe at Planet
12233          400                 2        Hollywood.

How can I get the result to look like this in SQL?:


check#      check_line            des
12233          100                Joe Smith Trip to Vegas
12233          200                Cab pickup @ 5:45pm to Palms  wait time 12 minutes.
12233          300                Meals
12233          400                Dinner w/ Jane Doe at Planet Hollywood.

Many thanks in advance,

Regards,

Zack H.