The requested ship date only rolls down to the lines at the time that the order is created. One method to roll down requested ship dates from the header to the lines would be in a SQL Server trigger. The following trigger would do the trick, but needs more thorough testing. It checks to make sure that...

Would be curious if anyone has SQL queries for various reporting functions. I would be willing to share Excel tools (to be published to SharePoint) developed from such queries. For example, I need Sales Tax report Column Headers are: Transaction Date, Tax Detail ID, Tax Detail Description, Tax %, Doc...