Eugene Elutin (8/12/2010)

---

Mike Nuessler (8/12/2010)

---

Nothing fancy there it evaluates the conditions in order.

So the first condition (a=0) of the OR is evaluated and it will not look at...

Nothing fancy there it evaluates the conditions in order.

So the first condition (a=0) of the OR is evaluated and it will not look at second condition (b=0) unless...

We're looking at upgrading from 2K to 2K8 as well...

Ok, now that you're taking opinions..

My opinion would be not to do it. Whether it's a production or development SQL2K DB server all you want running on that machine...

I think Peter has proven his case here..

Thank you to everyone for suggestions; in the long run every one is valuable to improve my SQL skills.

Cheers, Mike

I just tried it again. Copied straight from your post, pasted into QA, and ran...

I just created a stored procedure for Peter's method and executed the two of them.

Sergiy's proc...

It appears I may need to modify my production code *sigh* thanks to Peter...

After modifying his original post for SQL2000 method to sort properly it works great!

Here's the modification:

[font="Courier New"]Declare...

Interesting.

I am going to modify your suggestion as required for my needs and run it on production data against my modified Sergiy method and see what happens.

Null fields...

Whoops...Sorry, forgot to index my test data :blush:

Yet another method. Thanks Peter.

The output results aren't exactly what I need (but I think you're editing the post as I type this because I've tried 2 different query...

Ok, Sergiy wins. Lightning fast and easily maintainable if required.

I had to look at that function line a few times ... SET @Count = ReviewNo = CASE ... to...

Another interesting approach. Thank you. The data doesn't result in the format I need with this method however. It creates a nice comma-delimited dates per year instead....

Thank you - I thought there had to be a way but couldn't quite get there and wasn't given the time to work it out.

Checking the execution plan I see...

I think it's complaining about the line continuation character actually.

try

q = DTSLookups("FiltroStoricoIdLotto_Lookup").Execute(DTSSource("Id"), DTSSource("Lotto"))

instead of

q = DTSLookups("FiltroStoricoIdLotto_Lookup")._

Execute(DTSSource("Id"), DTSSource("Lotto"))