Sorry, the problem is that it still generated an empty excel file. I'm going to try your new code to see if it works.

Thank you very much for...

Thanks,Phil. I've tried your code and it worked as expected. However, in my case, there are still some problems. In the original post, I over simplified the SP code....

Thank you very much, Gail.

UPDATE:

We removed a Count(*) function in the query, and the performance improved significantly.

Thanks to everyone's suggestion.

very good reference. Thanks.

Thanks, Gail. I'll discuss it with my DBA.

Thank you for your reply, Kevin.

Per your questions:

#1. Yes, it uses views, instead of tables;

#2. It only returns about 5-10 rows per question ID. It take 1-2 second run...

Thanks, dwain.

It works!

This is great, Thanks, Steve!

Thank you, Chris. Your solution works about right.

The issue remaining is that the Product Pencil is also shown in the result. It's not supposed to be there since there...

Thank you for your reply, Steve.

I've tried your suggestion, and it didn't work for me. I think your query is somehow based on status, so if I remove the...

Sorry for the confusion. Let me try my best to clarify the question a little.

Some products we sold were returned by customers, and we'd refurbish them and put them...

Thanks, everyone.

As suggested, I'm not going to try it.

Thanks, I was able to upadte my table.

Thanks, Roland. It works perfectly!