This has worked very well 🙂

Thank you

Hi,

Not sure what you meant but here is some sample data:

Person table:

PersonIDFirst NameLast Name

1BobPatel

2LunSmith

3JulieTaylor

4ChrisPain

5JoeBloggs

Relation table

RelationIDBossIDSlaveID

123413

32133

23115

(not sure how to paste in a table)

What I need to work out as how...

Thanks for you reply.

A trigger would be a more appropriate solution.

Hi thanks for your reply.

I managed to do what you have suggested.

I created many groups which caused the report not to be properly grouped.

Cheers

Thanks for the hint!

This worked:

SELECT name, COALESCE(NULL, NULL, 'No Manager')

from Tutti.dbo.TBL_EMP

Cheers

Hi Guys,

Just another question, I have to write a query which returns the names of each employee along with their manager’s name, or ‘No Manager’ if none is defined.

The...

Hi guys,

Thank you for the reply now I understand how to carry this out in the future.

You have both been very helpful

Thanks again

Yep, all permissions were fine.

I tried everything...

I ran the repair on SQL Server 2008 and find out it is not reading the master.mdf and mastlog.ldf.

I then decided to restore at...