Jeff, moving the (SELECT ABS(CHECKSUM(NEWID()))%3) from the CROSS APPLY into the CASE seems to work as well. When should CROSS APPLY be used, or is it equivalent in this...

I'm looking for an answer to this too. I guess I'll try Google...

I need to implement something like this soon. This article is a few years old so I'm wondering if there are other ideas out there. If not, is...

I'd say just the opposite....

Excellent article. Thanks Sushila. And I agree with Jeff that this should be required reading.

Steve, any way to pin this article to the top of the heap?

I use ApexSQL Edit as my IDE but I agree with William. I'd like to see a single great IDE. I toggle between Apex and SSMS.

I've found RANK() to be very useful in many scenerios especially with the PARTITION BY clause. One scenerio was where I built an SSIS package that outputs data to...

Well done Peter. I like the versatility. Great examples.

You could even populate the holiday table this way, at least when they are defined like the Civic Holiday or...

Perfect timing! I was able to use this logic for a report today. It made short work out of an otherwise arduous task.

Thanks.

And whenever you get a new cell phone you have to rebuild the contact list from scratch. Aargh!

Try replacing "count(*)" with "count(distinct score)".

Is that what you mean?

J

Wow, I'm overwhelmed by the response here. Thanks much. I was out of the office today and will be again tomorrow but I'll try to clear up some...

Thanks Sergiy. I tried your query and get "Column 'T2.DayNumber' is invalid in the select list because it is not contained in an aggregate function and there is no...

I'd rather have a bottle in front of me than a frontal lobotamy.

Wow. Lot's of good ones here. I don't think I can pick a single favourite. Maybe a dozen or so. I didn't see the following movies...