My bad! It's working now. Thank you so much!

For some reason it's giving me a syntax error with d1.[Vendor Name] after the select command.

Forgive my ignorance here.

How would I do the select and union all select as a variable?

select 'Company123', '11445','11112','20180502',123456

union all select 'Company123', '11445', '11113', '20180601',123456

union all select 'Company123', '11445', '11116', '20180608',123456

The...

In some cases I have 20 or more invoices and invoice dates on one check so I would have to add more

,ltrim((select ' '+d4.[Invoice No]

commands.

I also see an advantage to...

select @@version = Microsoft SQL server 2012 - 11.0.2100.60(x64)

And my desired output.

• This reply was modified 5 years, 8 months ago by  ccameron 64337.
• This reply was modified 5 years, 8 months ago by  ccameron 64337.

This is an example of the data.

• This reply was modified 5 years, 8 months ago by  ccameron 64337.

Thom, Thank you for the input. I decided to import the smaller database into a separate table. My thinking there is that it would be easier since both now exist...