Skip to Content
Former Member
May 21, 2016 at 12:06 PM

Show all returns from a query without manually sort, also count returns by value


I have this code:

select LastReqTime,



from sa_conn_info()

WHERE LastReqTime < DATEADD(mi,-60,GETDATE()) AND BlockedOn > 0 AND UncommitOps = 0

An example of the return is:

Is there a way to instruct SQL to return and show all values, without limiting the display? In the above

query, it shows the first 115 rows and I must manually sort or scroll down to see the total number.

Also is there a way to get a count of each unique BlockedOn value, for use in a different query?