SQL already captures the vast bulk of the stats you need, thus you don't generally have to set up separate runs, etc. to capture activity.

If you're willing to run the...

DECLARE @EndDate date
DECLARE @StartDate date

SET @StartDate = '20220101' --<<-- change @Start and @End values to get any date range you want
--get end of current month
SET @EndDate =...

Btw, you should always specify nullability (NULL / NOT NULL) when ADDing a column, otherwise it's extremely difficult to determine what you'll get there.

To get the last datetime for a given set of datetimes, you'd typically use ROW_NUMBER(), like this:

select ...
From (
    select *, row_numnber() over(partition by...

Hello everyone!

I am in dire need of some assistance or direction. I am by no means a expert at any of this stuff. Unfortunately for me the...

Hello everyone!

I am in dire need of some assistance or direction. I am by no means a expert at any of this stuff. Unfortunately for me the company...

SELECT CONVERT (decimal(9, 2) , CAST('$15,000.50' AS money))

No need to specify the last day / number of days in the month, that can easily be calculated:

(CASE WHEN MONTH = @month AND DAY = @day...

I agree.  In fact, any book on T-SQL by Ben-Gan will be worth studying.

You might find it easier to reason about with EXCEPT and INTERCECT.

SELECT DISTINCT KEY FROM myTable WHERE type = 'COLL' and subtype = 'MOD'

EXCEPT

SELECT DISTINCT KEY...

Yes.  If you only want a key that has both conditions, change the MAX:

MAX(CASE WHEN type = 'QUAT' AND subtype = 'BALANCE' THEN 1 ELSE 0 END) = 1

Note that...

SELECT key
FROM dbo.your_table_name_here
GROUP BY key
HAVING MAX(CASE WHEN type = 'COLL' AND subtype = 'MOD' THEN 1 ELSE 0 END) = 1 AND
    MAX(CASE WHEN...

I don't think so.  PIVOT works on only one column at a time, IIRC.  A cross-tab is almost certainly the best method here.

Great point; sorry, I accidentally left out that "current year" requirement.

If you just want the MemberID, then as below.  Of course you can adjust the query against the cte to pull more columns if you want them.  Either way, I...