Session

[Prabhu]

Hi all,

I need some solution..
When i execute a program it first deletes all datas from a
'X' table .Then fetches data from various other tables and
inserts into this 'X' table.I finally generate a report from
this 'X' table.

Now the problem is,
USER 1 : Executes the program - Datas in 'X' table got deleted and
filled up with new data.Report is getting processed.....
USER 2 : Executes the same program - Datas in the same 'X' table
getting deleted ..
So the report process of USER 1 got affected.

Solution 1 : Using IP address of local machine i solved the problem.But
i need a concrete solution for this ..something related to sessions..

CAN ANYONE HELP ??

Thanx and Regards
Prabhu

[Ivo]

Hi,
I think most useful solution is to use @@SPID value of the process running report query. Use it with deleting also, so you can have as many as you want concurrent users ...
Ivo


------------
Prabhu at 9/20/01 3:25:20 AM

Hi all,

I need some solution..
When i execute a program it first deletes all datas from a
'X' table .Then fetches data from various other tables and
inserts into this 'X' table.I finally generate a report from
this 'X' table.

Now the problem is,
USER 1 : Executes the program - Datas in 'X' table got deleted and
filled up with new data.Report is getting processed.....
USER 2 : Executes the same program - Datas in the same 'X' table
getting deleted ..
So the report process of USER 1 got affected.

Solution 1 : Using IP address of local machine i solved the problem.But
i need a concrete solution for this ..something related to sessions..

CAN ANYONE HELP ??

Thanx and Regards
Prabhu

[Juergen Leis]

If all that happens within a single connection
a temporary table would be a simple approach.


------------
Ivo at 9/20/01 7:49:20 AM

Hi,
I think most useful solution is to use @@SPID value of the process running report query. Use it with deleting also, so you can have as many as you want concurrent users ...
Ivo


------------
Prabhu at 9/20/01 3:25:20 AM

Hi all,

I need some solution..
When i execute a program it first deletes all datas from a
'X' table .Then fetches data from various other tables and
inserts into this 'X' table.I finally generate a report from
this 'X' table.

Now the problem is,
USER 1 : Executes the program - Datas in 'X' table got deleted and
filled up with new data.Report is getting processed.....
USER 2 : Executes the same program - Datas in the same 'X' table
getting deleted ..
So the report process of USER 1 got affected.

Solution 1 : Using IP address of local machine i solved the problem.But
i need a concrete solution for this ..something related to sessions..

CAN ANYONE HELP ??

Thanx and Regards
Prabhu