Hi all, I have a table that holds the following;
Username, Workgroup, ActivationFlag & MaxDate
I want to return the number of workgroups that are activated for the user if the Maxdate is the most recent and Activationflag = 1.
For example, I wouldn't return the workgroup "GBR 1471 Call In" in the results because the MaxDate of the deactivation (ActivationFlag = 0) is greater than the Activation (ActivationFlag = 1)
But I would want to return "GBR DJ Test Call In" because the max date of the activation (ActivationFlag = 1) is greater than the De-Activation (ActivationFlag = 0)
I'm hoping someone can help me, I've tried it all different ways but I'm yet to crack this one.
Thanks in advance