Database

firestoper wrote:

You've just enlighten me

Regards,

Satips.

Don't walk in front of me, I may not follow;
Don't walk behind me, I may not lead;
Walk beside me, and just be my friend. - Albert Camus

rajugrover wrote:

the table says that s1 is the boss of s2. if s1 does not have a boss then s2 is null

rajugrover wrote:

I mean starting from manager1 select recursively down to the last leaf.

Colin Angus Mackay wrote:

SQL isn't so good at recursion

Pete O'Hanlon wrote:

It's up to you to figure out how to do it - if you don't, how are you going to be able to maintain it.

Pete O'Hanlon wrote:

Have they no pride in their work?

CREATE TABLE employees(
  ID      INTEGER
, name    VARCHAR(50)
, lineage VARCHAR(60)
);

INSERT INTO employees(name) VALUES (@mployee_name) ;

UPDATE employees
SET    lineage = (SELECT lineage 
                  FROM employees
                  WHERE name = @manager_name) || ',' || ID
WHERE lineage IS NULL;

SELECT * FROM employees WHERE lineage LIKE 
(SELECT ID FROM employees WHERE name=@manager_name) || ',%' ;

DELETE Item
FROM table1 WHERE MyValue IN (
SELECT MyValue2 FROM Database2.dbo.table2 WHERE MyCondition = 'Hello'
)

Sandep H S wrote:

its urgent

Sandep H S wrote:

Please guide me on how to store data and access
that stored data in ASP.NET using SQLSERVER.