I think that sql server is assuming that you are trying to do a correlation query and since the field exists in the first query it doesn't error out..

have you...

The problem is not how to get the rank, but what is the best method to get it. Remember that he must be able to select a single line...

1 - Do you really need to have all left joins for this query? This can cause great performance degredation on larger tables.

2- Try running sp_who to see if...

He'd be back to square 1... how to generate/hold the rank value?

A function as the same nested level limit of 32 so it wouldn't do any good in this case.

Not that I'm aware of.

Could you post the query that you are running so then we can provide a better solution.

My first idea would be to do something like this.

Select MyFields from dbo.MyTable WITH...

From what I've read on this site, it is considered a best practice to split the web server and sql server into 2 machines. Long story short, the web...

can you send me that top list? I'd love to see a bundle of those neat tricks.

Case is the version of an if in a ddl statement (select, insert, update...), but that was a pure workflow statement. That's why it didn't work.

Since you are talking about 100 levels of nesting you are probabely better off using your current setup even if it's not considered best pratice. Just make sure you...

I haven't read all the code but maybe this seems to be reapeating :

OPEN tCursor

FETCH NEXT FROM tCursor

INTO @dbName

-- Stripping the _Data.MDF from each returned value from

-- ...

Nesting = hierarchy,

hierarchy cannot be defined using a single select statement unless you know that there is a last level limit in which case you make the appropriate number...

Select max(DatePurchase) from dbo.OrdersItems where Item_id = ???

or the last purchase date for each item :

Select Item_id, max(DatePurchase) from dbo.OrdersItems where Group by Item_id

I use to have split function that would parse a string of comma delemited values and return them into a table. It was using a while loop to scan...