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...

Yes they will both work.. it's just a matter of preferrence, I preffer to avoid errors when I can. Especially in vb6 where err handling is a big pain in...

You'll have to do load testing. If you expect to have let's say 5000 rows in your table, then I'd test for 15 000 and even 50 000 just...

You could run something like this...

IF EXISTS (Select * from dbo.SysObjects where Name = '#your table name#' and XType = 'U')

SELECT 1

ELSE

SELECT 0

This would return one if the table exists....