Are you doing transaction log backups of this database?  If so, you might be able to narrow down when the data changes are occurring by looking at the backup history:

maybe something like:
SELECT a.itemno, b.itemcode,
    CASE a.itemdesc
    WHEN 'aprove' THEN a.closedate
    WHEN 'inprogress' THEN a.opendate
    WHEN 'reject' THEN a.eventdate
    END AS...

Most recent computer at home I built I named Prometheus, because it was such an upgrade from the old Core 2 Duo computer it replaced.  My Linux box is just...

If you're not sure if you're using features that are Enterprise features, this system view can help:
https://docs.microsoft.com/en-us/sql/relational-databases/system-dynamic-management-views/sys-dm-db-persisted-sku-features-transact-sql

Even before it was completely free, Developer edition was relatively...

I think Luis is on the right track, but instead of making the sort as a column called Orderby in SUB, I'd just remove that line completely and in your main query...

I agree with article posted above, it can seem overwhelming though.  One of the first things I check is mentioned in section 2.5 of that article, "The Default Settings".  Check...

I'm not arguing against whitespace, I vertically use whitespace to separate things, and indent code all the time (even if I'm just writing a 3 line ad-hoc query).  I just...

Are both the ad-hoc query and the stored procedure being called in the same way, or was the stored proc automated?  Something to check is that the sessions running these...

I just miss the days when SSMS was 160 MB download, instead of a 900 MB download.

I'm not sure I like the idea of significant whitespace, oh well I did get the question right since I remembered this as one of the reasons I didn't want...

Could you put these in a separate stored procedure?  If so, you could setup a parameter in the report, have the Available values and Default values defined as "Get values...

I actually keep a spreadsheet with all the database servers in it.  I use a free third party tool from Idera to discover instances on the network and track their...