Hi guys,

My apologies, just realized that I pretty much repeated code already posted by someone else (never do things in a hurry!).

MB

LOL

Just realized, my previous post is same as:

select a.UserId,a.columnA,a.ColumnB from tableA a

left outer join FlaggedRecords b

on a.USerId=b.USerId

where ((@Flag=0 ))

Or

(@Flag=1 and b.UserId is not null)

Even easier!

Hi,

I believe that htis will solve your problem:

select a.UserId,a.columnA,a.ColumnB from tableA a

left outer join FlaggedRecords b

on a.USerId=b.USerId

where ((@Flag=0 and b.UserId is null) or (@flag=0 and b.USerId is not...

Hi

I could not really see how does this relate to SQL Server or TSQL, but let's give it a try...

Please, note that this is not the complete solution but the...

Hi

You could also use:

execute sp_MSforeachDB @command1="use [?] select * from dbo.sysobjects where xtype='U'"

Keep in mind that system databases will be listed as well, although I don't think that should be...

Try to rebuild the indexes on the tables that are used in that query

(If it suddenly starts working slower and recompiling doesn't help, set statistics io shows big numbers it...

Additionally,

This (is not very elegant, I know) would return records from your example

DECLARE @tbl TABLE (Id INT , [Name] char(3), Lft INT , Rit INT , ParentId INT )

INSERT @tbl...

Hi

Your query is returning ALL the left nodes, starting from node 1. (matches description of what you want)

Based on your example it seems that you want FIRST LEFT NODE to...