Thank you very much - I was able to determine that adding "-NoTypeInformation" to the output file command line at end resolved the issue.

I did try to research independently before...

Thank you so much for the prompt reply and for the assistance in properly posting data. It works beautifully.

I will need to study up on the CROSS JOIN. I had...

Thanks for the reply. I will refrain from pasting picture of code.

A little background - MO = Manufacturing Order. Dataset has one record for every Manufacturing Order. Objective is to...

Scott - worked quite well as well. Nice to have two options to review and learn from. Your query requires grouping all the data elements but it's simplicity (even I...

I will try this reply as well. Thank you so much for taking time to reply.

Phil - your response worked beautifully for me. Thank you very much.

Thank you both - Sue and Lowell..........

Quick follow up question - my step 2 is to update the table by setting the NOTICE_SENT column = '1' - is a simple...

Luis - Thank you so much.

I should have known that I didn't need to make the additional joins to the one-to-many relationships tables C and D.

I knew why I was...

Thanks - that's what I ended up doing. Works great except having hard time getting the DocNumber group to repeat on each page. Group Properties doesn't do it - I...

Thanks for the replies. This forum never disappoints.......

Craig - I tested your solution for a multi-level BOM and it worked great.

Thanks for your assistance..........

Okay - as Craig was posting his reply (thank you very much) I wrote my first CTE!!! - I created a string (thinking I might be able to use in...

Thanks for the reply.

My two tables are the readers digest version of actual ERP software tables. I didn't bother stating primary keys or NOT Nulls.....(sorry)

Both machinetime and labortime (you thought...

Sorry Jared - I called you Jeff. In the reply screen I can't see previous psotings - I was goping by memory - many apologizes......

Jeff -

Pretty cool to meet someone else who has worked with Great Plains. My client has a user who's system locked up while posting a sales invoice. The invoice...