Well technically the DNS is for the 'Listener' for the AG, not the AG itself. Not sure if that's what you meant. But if you have a Listener,...

It's not a matter of getting the PunchIn and PunchOut. Whoever wrote this query is using a another field to grab what is considered PunchIn and PunchOut, a field...

Basically im looking at a query for someome. Someone (not me) wrote this query to grab the punchin time for employees and punch out time. The problem is...

Facetious about what?? Adding to a much more complex query, or making the logic more complex? I'd like to keep the logic as simple as possible, but the...

Thank you both very much. Im using a CTE pretty simply now.

with cte as

(select name, col2, col3, COUNT(*) over (PARTITION By Name, col2, col3) as freq

from...