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,