I am currently using Toad Data Point 3.2 and I am connected to a Sybase IQ reporting table, my issue is I’m trying to concatenate multiple columns of data into one row. I’ve looked around many sites and have tried different techniques with no success. Here is a break down of what I need…
Temp table = [tag:finaltbl]
The table mentioned above contains data with these columns (record_ID, seq_Number, txt_Notes)
The data is as follows:
record_ID seq_Number txt_Notes
111 0 this is some text that
111 1 continues on the next sequence
111 2 number and would like
111 3 to combine into one row.
The above table results I would like to view is:
record_ID txt_Notes
111 this is some text that continues on the next sequence number and would like to combine into one row.
I’ve tried using XML Path (doesn’t work), Concat (doesn’t work) and a bunch of other methods but they don’t seem to either work or produce the end results.
Hopefully someone here and point me into something that can get me what I need, I appreciate any help and thank you in advance!