Last post May 26, 2015 10:57 AM by dotnet_bug
May 25, 2015 09:40 AM|dotnet_bug|LINK
I have two tables:
1st one to capture Login and Logout datetime: Table1
2nd one to capture links accessed by users: Table2
I need to show the data in a report, the output will be:
Can anyone suggest a solution or idea?
May 25, 2015 07:27 PM|gimimex|LINK
[DateColumns] as [Activity],
select [UserId], [LoginDate] as [Login], [LogoutDate] as [Logout]
) as t
[Date] for [DateColumns] in ([Login], [Logout])
) as u
Hope this helps.
May 26, 2015 10:57 AM|dotnet_bug|LINK
Thanks! Your solution worked.