I'm thinking there are two schools of thought on that... a system that constantly updates indexes like SQL Server for new rows, and a system that has never seen the...

Thanks... any chance of you posting that script?

What's your point, Andrew? You said the code didn't work... I told you why it didn't. 😉

Please show me a Microsoft document or viable test code that proves that. 🙂

Thanks for the feedback, John. 🙂

Dunno about that, Mark... I've never had a problem with xp_DirTree and UNC's. If SQL Server can see it, xp_Dirtree can read it in my humble experiences.

I don't know any gentle way to say it... Inserts, updates, and the occasional block delete...

Crud... I was hoping they were unique so we could use xp_Dirtree to solve your problem very easily. xp_FileExists is not available in SQL Server 2k8 like it is...

I agree... if the VB code works and there is no impact on performance, there's no reason to change horses right now.

Thanks. Oh, and the randomness comes from the fact that NEWID generates random numbers. If you order by a random number like that, the result will be in...

samsql (10/1/2008)

---

jeff waiting for the reply

how many rows are there with 3 not null values and

how many rows are there with 4 not null values

from column image1 to...

I've answered several of your questions and provided a code solution... the least you could do is answer just one of mine... what is the purpose of this code?

Heh... I already know that... but, why is it a requirement? What is it that you are trying to do? ie. ...

A CTE is nothing more than a "derived table" or an "inline view"... both of which are just sub-queries. If you did it the "old way" without a CTE,...

Yeah... You'e right. I misread your requirements. Sorry.

If you could provide a little test data...