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:

Table1
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.

Note
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
0
 
jorge_torizResearch & Development ManagerCommented:
Search for an udagg that concatenates your rows
0
 
Nathan RileyFounderAuthor Commented:
udagg?
0
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
0
 
Nathan RileyFounderAuthor Commented:
yeah, if I knew .net
0
 
Nathan RileyFounderAuthor Commented:
Ok, thanks.
0
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.