Flag Update - SQL Server Forums

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.

All Forums

General SQL Server Forums

New to SQL Server Programming

Flag Update

Author

Topic

WoodHouse
Posting Yak Master

211 Posts

Posted - 2010-01-27 : 05:03:57

Hi

any help...

I want to maintain the approve matrix for below table structure. which means how to maintain the flags..

Table Columns
ID -- where ID columns is the User ID.
UNIQUE_ID
DESC

Sample Approve matrix



USER   ADMIN    STATUS
YES		NO	Approved
NO		YES	Rejected
NULL		YES	Approved
YES		NULL	Approved



ADMIN		USER	STATUS
YES		NO	Approved
NO		YES	Rejected
NULL		YES	Approved
YES		NULL	Approved

Thanks

EugeneLim11
Posting Yak Master

167 Posts

Posted - 2010-01-27 : 06:17:14

Err. what is your question?

WoodHouse
Posting Yak Master

211 Posts

Posted - 2010-01-27 : 06:22:41

I need to maintain the flag based on the approve matrix which i have given

for example we have employee table.

If i send ID based on the ID find out manager ID that is Admin...

User and irrespective of Admin user both can approve the record.

for this...i have to maintain flag status...

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2010-01-27 : 11:42:18

you're not clear. would you mind posting data in below format/

http://weblogs.sqlteam.com/brettk/archive/2005/05/25/5276.aspx

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources