How to calculate totalActivity and lastActivity?

Question

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

Nisha Regil · Answer

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

Nisha Regil · Answer

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)

Guest User · Answer

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'

How to calculate totalActivity and lastActivity?

Answers (3)