Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
hornet
Yak Posting Veteran
96 Posts |
 Posted - 2007-08-09 : 01:44:32
|
| Hi all!There is a table. There a lot of types of users. All data are contained in a table but a user can work with him data only. But in the same time under one type of user can work also a lot other users (e.g. user - company (has the same login for all employees) and there are employees in this co). I need to use a tran statement in proc so that in the same time with data related with 1 login's user can work only one user but users with other logins can work also.How it possible?Thanks in advance! |
|
|
hornet
Yak Posting Veteran
96 Posts |
Posted - 2007-08-09 : 01:45:39
|
I feel sorry for incorrect Topic Firstly thinked about Cursor but sorted out |
 |
|
|
|
|
|
Need replace iteration instead of CURSOR