Viewing 15 posts - 1 through 15 (of 15 total)
I like NULL because it enables a limited, trinary condition. Suppose the acceptable values for a column are TRUE or FALSE. Enabling NULL for that column enables three conditions: TRUE, FALSE,...
July 6, 2018 at 6:12 am
P.S. I've been writing code of one kind or another since 1965, and I missed the closing parenthesis in my post, above, truly by accident. Color might have...
May 8, 2012 at 2:01 pm
And besides all that, upper case letters take more ink. Pretty soon your screen is bound to run out of it. Then where will you be?
Seriously, legibility is...
May 8, 2012 at 1:58 pm
Jeff, Kevin, tmarkham et. al.,
Nice job! I'm truly impressed.
I'm a long time believer in the value of peer review. Just look at what came of this discussion.
May 6, 2012 at 12:57 pm
Just for the record, I *LIKE* recursive code. I've written a lot of recursive code in various languages over the years, as well as reusable and reenterable code.
May 3, 2012 at 9:48 pm
Dave Brooking (5/3/2012)I'd be interested in knowing which version(s) of SQL Server Chuck is using/supporting.
Dave Brooking (5/3/2012)
2000, 2005, and 2008.
May 3, 2012 at 6:13 am
Isn't this same function much easier to realise with an rCTE?
Thank you Miika.
I think the choice of approach must depend upon the environment. For a shop whose TSQL writers...
May 3, 2012 at 1:15 am
You would still need one CASE statement for the ASC sort, and one for the DESC sort for a particular column.
You could use those same two CASE statements to sort...
April 26, 2012 at 8:13 pm
There are FOUR spams, all worded the same.
1282864, 1282865, 1282866
April 12, 2012 at 9:16 pm
I agree with Jack.
It happens that most of my applications are written in ColdFusion. Each language would be different but you can get the idea from the following ColdFusion...
April 12, 2012 at 8:06 am
The following TSQL will produce two output sets.
If you put this TSQL into a stored procedure the application software you use should be able to select which output set you...
April 11, 2012 at 12:59 pm
I would put your choices into a second table. This second table could be a temporary table or a table variable.
I agree that you should have provided the table...
April 10, 2012 at 11:54 pm
You could use CASE statements in the proc because you were only using the IF statments to select the column. This might make it a little easier to maintain...
April 10, 2012 at 11:09 pm
Thanks for your post, Andy. I think yours is a nice, clean approach too. You're right, I didn't need the zeroes when initializing the masks. The zeroes...
April 9, 2012 at 1:34 pm
Thank you, Jeff. I appreciate it.
April 9, 2012 at 8:26 am