Is there a Beast Mode equivalant for this SQL? Can Beast Mode even accomodate something like this?
select * from TABLE
where ResolvedBy in
(select distinct ResolvedBy from TABLE
where AssignmentGroup = 'IT Ops T1 Tickets'
and ResolvedBy != '')
and AssignmentGroup = 'IT Ops T1 Tickets'
order by ResolvedBy asc;
I know it can be done in a DataFlow, but I was told that Beast Mode can take pretty much any SQL scenarios. However, I have yet to figure out, or determine if the above is possible.