Viewing 15 posts - 1 through 15 (of 23 total)
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...
August 28, 2013 at 12:31 pm
I'm looking for an answer to this too. I guess I'll try Google...
May 6, 2009 at 12:23 pm
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...
February 26, 2009 at 7:46 am
... those otherwise opposed to using the relational engine in this fashion, would be the first to store XML, a blob, etc. in the database...
I'd say just the opposite....
December 5, 2007 at 1:57 pm
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?
October 18, 2006 at 7:46 am
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.
October 6, 2006 at 6:35 am
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...
October 5, 2006 at 6:44 am
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...
July 19, 2006 at 8:49 am
Perfect timing! I was able to use this logic for a report today. It made short work out of an otherwise arduous task.
June 12, 2006 at 3:40 pm
And whenever you get a new cell phone you have to rebuild the contact list from scratch. Aargh!
June 7, 2006 at 10:54 am
Try replacing "count(*)" with "count(distinct score)".
Is that what you mean?
March 23, 2006 at 10:16 am
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...
February 20, 2006 at 9:25 pm
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...
February 16, 2006 at 2:53 pm
I'd rather have a bottle in front of me than a frontal lobotamy.
January 30, 2006 at 2:12 pm
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...
December 2, 2005 at 10:55 am