Manager ID - 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

SQL Server 2005 Forums

Transact-SQL (2005)

Manager ID

Author

Topic

jogin malathi
Posting Yak Master

117 Posts

Posted - 2007-02-09 : 05:06:49

hi all

if i want to assign manager for a employee as employee id by using self relation

based on which conditions i can assign

Malathi Rao

khtan
In (Som, Ni, Yak)

17689 Posts

Posted - 2007-02-09 : 05:15:30

please post your table structure, with some sample data and the result that you want

jogin malathi
Posting Yak Master

117 Posts

Posted - 2007-02-09 : 06:15:47

DepartmentMaster(deptid int PRIMARY KEY,deptcode varchar)

DesignationMaster(desgn int PRIMARYKEY,desgncode varchar)

EmployeeMaster(empid int PRIMARY KEY,empname varchar,deptid int FOREIGN KEY,desgn int FOREIGN KEY,managerid int FOREIGN KEY(EMPLOYEE MASTER)

1 Malathi Rao 1 1 1

Malathi Rao

harsh_athalye
Master Smack Fu Yak Hacker

5581 Posts

Posted - 2007-02-09 : 06:41:03

Check this:

[url]http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=78864[/url]

Harsh Athalye
India.
"The IMPOSSIBLE is often UNTRIED"

khtan
In (Som, Ni, Yak)

17689 Posts

Posted - 2007-02-09 : 07:35:48

quote:
Originally posted by harsh_athalye

Check this:

[url]http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=78864[/url]

Harsh Athalye
India.
"The IMPOSSIBLE is often UNTRIED"

jogin malathi is indraja ? ?

harsh_athalye
Master Smack Fu Yak Hacker

5581 Posts

Posted - 2007-02-09 : 07:40:44

"jogin malathi is indraja ? ?"
I suspect they are because profile of both users is pretty much same.

I don't see any point in posting same question under two different user names, though !

Harsh Athalye
India.
"The IMPOSSIBLE is often UNTRIED"

jogin malathi
Posting Yak Master

117 Posts

Posted - 2007-02-12 : 02:07:43

quote:
Originally posted by harsh_athalye

"jogin malathi is indraja ? ?"
I suspect they are because profile of both users is pretty much same.

I don't see any point in posting same question under two different user names, though !

Harsh Athalye
India.
"The IMPOSSIBLE is often UNTRIED"

don't make fun of us we are collegues

Malathi Rao

jogin malathi
Posting Yak Master

117 Posts

Posted - 2007-02-12 : 02:09:08

quote:
Originally posted by khtan

quote:
Originally posted by harsh_athalye

Check this:

[url]http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=78864[/url]

Harsh Athalye
India.
"The IMPOSSIBLE is often UNTRIED"

jogin malathi is indraja ? ?

KH

don't make fun of us we are collegues

Malathi Rao

khtan
In (Som, Ni, Yak)

17689 Posts

Posted - 2007-02-12 : 02:12:56

quote:
Originally posted by jogin malathi

quote:
Originally posted by harsh_athalye

"jogin malathi is indraja ? ?"
I suspect they are because profile of both users is pretty much same.

I don't see any point in posting same question under two different user names, though !

Harsh Athalye
India.
"The IMPOSSIBLE is often UNTRIED"

don't make fun of us we are collegues

Malathi Rao

We are not. Just kind a strange coincidence for 2 people asking the same question

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources