A solution could be:

Reverse the value of the field, find the backslash, copy it including the backslash, reverse it back and remove the backslash.

When you are absolute sure that there...

You asked:

provide me the ordered list by name field, how do I such thing?

i.e:

\\122.12.7.40\c\sistel\execv\dat\LOTNODOS.txt

\\OFI0675P25\VARIOS\DETALLE.TXT

c:\test\enr.txt

I am not sure what you mean.  What is the wanted result?  Is this...

Jeff,

Still thanks for your solution. Fine we found the same.

This is what I found on Google:

What if someone told you that RAND(N) was the following simple function:

   RAND(N) = the fractional part of 0.713573+N*1.8633E-05

Well guess what.  That's...

David

Instead of SIGN(ISNULL(op.PrefID,0)) could I use ISNUMERIC(op.PrefID)?

This also gives me a 0 on NULL and a 1 on non-null values.

David, thanks.

I just learned a nice new tric.

I can use it in other situations as well, I think.

David,

That's a nice new idea. I'll try this approach. Thanks

But what does that SUM SIGN ISNULL do? I don't think I understand the effect

Brian,

Thank you too.

Your explanation made it even more clear to me.

I miss an INALL function in SQL server (or the Sql standard). But with your help (and others on...

Kenneth, I saw your explanation, and now I understand why srama's solution fits only the "two params sql".

Thank you, your explanation is very clear

srama and kenneth, thank you.

Both solutions work perfect. They give the right answers, here in the demo, and also in my "real life" application. ...

Thanks.

You gave me insight in the way to handle this question.

But the real answer is: The query optimiser is so intelligent that it makes no difference (for the INNER JOIN...

I just figured it out myself:

SELECT * FROM @PeriodsPossible P

WHERE NOT EXISTS (SELECT NULL FROM @PeriodsUsed U

 WHERE (P.StartDate <= U.Startdate AND...

Jesper,

I had to write it out in a graphical way, to understand the logic of your (superb) solution. But the logic is clear when you see it in front of you....

Shrikant,

Why this PP.ID != PU.ID?

I used A,B,C versus 1,2,3 for reason of explanation (for an easy reference). In the real world the table PU (PeriodsUsed) has no ID, it exists...