There is no in-built way of getting this information.

Thanks to both of you for your input.  I'll look into changing the procs to populate the new tables, since as Phil...

or if you have 50 items (including 1 and 2) is that acceptable?

Correct.  Even though order id 789 contains 3 items, it should be included because Product ID's 1 &...

Thanks to everyone for the help!  I ultimately went with Drew's solution, as I need to ensure there was no trailing comma.

SELECT mt.Id, STUFF(COALESCE(', ' + Val1,...

Thanks for everyone's advice.  I ultimately went with Phil's idea of normalizing the data.  I was initially concerned with the number of records this would produce in the OrderRules table,...

Thanks @Taps!  That worked!!

Hi GilaMonster.

That actually did turn out to be the culprit.  TableB contains multiple records for each claim number in TableA.  HOWEVER, all "client_program_number" values in TableB will be...

Thanks to both of you. This helped immensely!

Thanks for the help. I ended up taking a slightly different approach:

INSERT INTO UserRankHistory(UserId, RankName)

SELECT

users.UserId, users.RankName

FROM

UserRankHistory

RIGHT JOIN (select c.UserId as UserId, t.RankName as RankName

FROM

Users...

Thanks for all of the responses. I went with your solution Dwain. Worked great!

Thanks PW

Actually, I'd personally prefer to work with access however I know both customers and employees will be utilizing this database in great numbers simultaneously and I know the content of...

"It doesn't appear that you set @InvoiceNo, which is used in the WHERE clause of each subselect.  It probably should be tbilling.billid and not @InvoiceNo."

That was it.  I needed to...