How to calculate totalActivity and lastActivity?

Guest User

6y768

Hi Team

I need some help, i have these two fields and want to filter their data types, but need some help as to how to work this out in sql server. Meaning TotalActivity must this format as output and LastActivity.

Oct 13 at 3:41am
21:02:04 // Must always counts when a user logs in and out

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

Nisha Regil6y ago
This query will give total activity
SELECT sum(TotalActivity) as sumTotalActivity
FROM [eNtsaRegistration_2].[dbo].[eNtsaRegPeopleLists]

This query will give last activity date
SELECT top 1 [LastActivity]
FROM [eNtsaRegistration_2].[dbo].[eNtsaRegPeopleLists] order by LastActivity desc
+1
Guest User6y ago
Hi Nisha
Thanks man, now how do i use
SELECT TOP (1000) [LoginID]
      ,[Name]
      ,[SISID]
      ,[Section]
      ,[Role]
      ,[LastActivity]
      ,[Institution]
      ,[EmailAddress]
      ,[TotalActivity]
  FROM [eNtsaRegistration_2].[dbo].[eNtsaRegPeopleLists]
it on this query for this record, 'TotalActivity' and 'LastActivity'
-1
Nisha Regil6y ago
I don't get your exact requirement.

But to get the date formats as shown by your output you can use the below you can use the sql statements as below

SELECT REPLACE(convert(varchar,getdate(),100),year(getdate()),'at')

SELECT substring(convert(varchar,getdate(),114),0,8)

+1