I applaud your sense of responsibility.

I will present the Old and main table approach again and offer the view for reporting. Perhaps the view will buy the...

I am very fond of the "OldPatientRecords" and main clean table approach. That is how I approached it. However, I did not get approval because it complicates...

Thank you!

May I ask why the covering index is a better choice? Thanks!

Thanks! I will probably just keep the existing one and ignore the one flagged as missing for now.

Yes, I can return data in xml format. The same sproc output is used by the app UI code and the app service code. App UI needs...

Jeff,

My apologies for being slow on understanding your question.

Your question is a valid question. I am doing database development for the application teams. The teams services that take...

Thank you Sean.

Jeff,

I am not sure why the question was about CSV format? My question is to get a comma delimited string as output.

Thank you, Chris. I got to learn the CROSS APPLY from your solution.

Many thanks!

Hi Sean,

The solution is perfect. Thank you very much for the help!

I learned about the stuff function from you...

Thank you for asking for clarifications. I was definitively unclear.

What I would like is a comma delimited string of order IDs that share the same product.

So when Order 1...

Thank you for noticing. I made the correction per recommendation and things are looking good.

That is exactly what I am looking for. Many thanks to you, Dwain.

Hi Bala,

Thank you for the replies. Typically, the status names won't be used in the final version. The final version will use Status IDs. My sample data...