Hi Peso,

Sorry the reply was late.Thank you. Its working fine.

Regards

Mahathi.

one problem is, if a user logins today and if loggins once again, it is not being displayed on the top position. It is displayed in the previous place itself.

...

Hi Peso,

Thank you for the query. It is working great.

Regards

Mahathi.

Should i apply the distinct keyword only for th user name. Even I tried that query. But I got the same result.

The eventId 14 is the eventid fro login

The UserActivityLog table stores the user login infromation and the schema of the table is:

CREATE TABLE [dbo].[UserActivityLog](

[RId] [int] IDENTITY(1,1) NOT NULL,

[ClientId] [bigint] NULL,

[UId] [int] NULL,

[Operation] [nvarchar](15) NULL,

[ReportDesc] [nvarchar](200) NULL,

[ReportDate]...

I got the solution for the requirement. Th following is the query used to get the most Frequent Allocations per day per client.

ALTER procedure [dbo].[mostFrequentAllocations](@ClientId bigint)

as

begin

select av.AllocId,a.AllocName,convert(varchar,getdate(),101) as VisitTime...

Sorry the previous post is not yet complete. I unknowingly clicked the enter button.

The count varaibe increments when any user visits a page called ViewAllocation and AllocId is...

I have a table named Allocation Visit and the schema of the table is as follows:

CREATE TABLE [dbo].[AllocationVisit](

[VisitId] [int] IDENTITY(1,1) NOT NULL,

[AllocId] [bigint] NOT NULL,

[VisitTime] [datetime] NOT NULL,

[Cnt] [money] NOT...

Hi Quatreix

Thank you clarifying my doubt. No problem, even if it is late.

Regards

Mahathi.

Hi

Everything works fine. One doubt is that please tell me why did you took convert(max)?

I am asking this question because, i used the same conevrt(max) to a text...

Thank you

Hi

Thank you for the help.

It works fine. If there are any doubts I'll again place it in the forum.

Thank you once again.

Regards,

Mahathi.

Hi

Thank you for the reply. Should I create three different procedures for today,tomorrow and yesterday. And what does the field @Item and @NewId mean?

Please clarify the above doubts.

Regards,

Mahathi.

Hi,

The data in the table for yesterday i.e., 16th sept is

AllocId VisitTime ...