Viewing 9 posts - 1 through 9 (of 9 total)
Phil Factor (9/15/2008)
...We got stuck, though, because we couldn't find a good genuine requirement for a CLR routine. We still can't.
We used CLR integration when we were developing an app...
September 15, 2008 at 2:54 pm
Wow, what a thorough explaination! I was tring to explain these concepts to some colleagues over lunch the other day, and your article beats the snot out of my back-of-napkin...
January 11, 2005 at 5:44 am
I think you are quibbling with semantics.
In terms of SQL Server Backups, I was under the impression that the term "Differential" is synonymous with "Incremental". If you look at your choices...
October 19, 2004 at 9:23 am
This technique is an oldie but a goodie.
One of Clinton Herring's contributions to "Script of the Day" a while back (I can't remember the date, but the script is dated...
September 9, 2004 at 4:24 am
Mike,
All arguments in the CASE statement used in your ORDER BY clause must be actual column names, not aliases.
In your situation, the following syntax should do the trick:
September 3, 2003 at 1:19 am
Mike,
When a CASE statement is used in your ORDER BY, SQL Server will return errors if the columns referenced in your CASE statement are not all of similar data types.
If...
September 3, 2003 at 12:56 am
Here's an example of using a CASE statement in your ORDER BY clause. Although there're a lot of things going on in this example, hopefully, you can easily see...
September 1, 2003 at 12:49 am
Wow.
Any idea how well this would scale on a production system?
Edited by - kenwallacedesign on 08/28/2003 10:09:41 PM
August 26, 2003 at 12:58 am
Excellent tip, bspiglejr!
Now, when using your CASE method of determining the ORDER BY criteria, would it be possible to also add an additional CASE statement to determine ASC or DESC?
Edited...
August 10, 2003 at 7:52 pm
Viewing 9 posts - 1 through 9 (of 9 total)