Larry Brister
asked on
MS SQL Server PIVOT QUERY
I have SQL below that returns valid data of seconds lag between rows entered by userid
I need a separate query I guess that shows how many records are entered PER 5 minute period PER AddedUserID
And it needs to be a pivot of course
AddedUsedID [+5] [+10]... etc...
101 23 21
Data Returned
I need a separate query I guess that shows how many records are entered PER 5 minute period PER AddedUserID
And it needs to be a pivot of course
AddedUsedID [+5] [+10]... etc...
101 23 21
SELECT u.FirstName + ' ' + u.LastName, q.AddedUserID,DATEDIFF(second, pDataDate, q.DateAdded) SecondsDiff
FROM (
SELECT *,
LAG(DateAdded) OVER (PARTITION BY AddedUserID ORDER BY AddedUserID,DateAdded) pDataDate
FROM Individuals WHERE CAST(DateAdded AS DATE) = CAST(GETDATE() AS DATE)
) q
JOIN Users u ON u.UserID = q.AddedUserID
WHERE pDataDate IS NOT NULL
Data Returned
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
I'll be at my desk this afternoon
ASKER
Perfect. Thanks
Some sample data would make it easier. Just need userid and dateadded.