Posted by marcsirois on 10/11/06 19:17

Hi there,

I think this would work:

===========================================
select T1.id, T1.name, T1.ParentTagId, T2.Name As ParentTagName
from Tags T1,
Tags T2
where T1.ParentTagId = t2.Id
===========================================

Thanks,

Marc

Andrew Tatum wrote:
> Alright, I have this table called Tags. The three columns of interest
> are Tags.Id, Tags.Name, Tags.ParentTagId
>
> This is the query I am currently using:
>
> Select Tags.Id, Tags.Name, Tags.ParentTagId
> >From Tags
> WHERE Tags.Id IN (
> 22536,
> 22535
> )
>
> This outputs to:
>
> Id Name ParentTagId
> ----- ------------ --------------
> 22535 Courses 148
> 22536 AEB3300-2204 22535
>
> Obviously, Courses is the Parent Tag Name to AEB3300-2204. How can I
> get this to show up so the results are something like
>
> Id Name ParentTagId ParentTagName
> ----- ------------ --------------
> --------------
> 22535 Courses 148 SomeName
> 22536 AEB3300-2204 22535 Courses
>
> Thank you all for your help! I truly appreciate it!

• Next in forum: Is there a way to view Stored Procedure, Trigger andFunction Usage in SQL Server?
• Prev in forum: Re: SQL 2005 Processor VS Cal
• Thread view: Re: Query Assistance Needed - Please

[Reply to this message]