Database

Harini N K wrote:

I am using SQL server 2005 and I have tried to modify the column as identity seed to NO using MS SQL Server Management Studio but it is hanging.

masyarial wrote:

select a.field1,..,tbl2.field3
from tbl2, tbl1 a
inner join
(select field1,.., from tbl1 group by field1,..) b
on a.field1 = b.field1 and ..
group by a.field1,..,tbl2.field3

The Question is: where I put the code:
a.field1 = tbl2.field1

<br />
SELECT a.field1,..,tbl2.field3<br />
FROM tbl2 <br />
    INNER JOIN tbl1 a ON a.field1 = tbl2.field1<br />
    INNER JOIN (select field1,.., from tbl1 group by field1,..) b ON a.field1 = b.field1 and ..<br />
GROUP BY a.field1,..,tbl2.field3<br />

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'
)