Syntax to Insert Many Rows to One

I'm trying to select many rows of data and insert them to on row separated by spaces example:

Debtor   Invoice
1               10
1               12
1               16
2                 4
5               20

I want to select all invoice numbers for Debtor 1 which are 10,12,16 and Insert them into my Note Table.

Debtor      Note
1                10 12 16

Since I have so many different Debtor's that I'm dealing with I have a cursor set up, but I don't know how to set all of those invoice numbers to 1 Variable?
LVL 12
Nathan RileyFounderAsked:
Who is Participating?
jorge_torizConnect With a Mentor Research & Development ManagerCommented:
Ups, there isn't other solution buddy
jorge_torizResearch & Development ManagerCommented:
Search for an udagg that concatenates your rows
Nathan RileyFounderAuthor Commented:
Cloud Class® Course: Amazon Web Services - Basic

Are you thinking about creating an Amazon Web Services account for your business? Not sure where to start? In this course you’ll get an overview of the history of AWS and take a tour of their user interface.

jorge_torizResearch & Development ManagerCommented:
Used Defined Aggregate... you can create your own aggregate using .net
Nathan RileyFounderAuthor Commented:
yeah, if I knew .net
Nathan RileyFounderAuthor Commented:
Ok, thanks.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.