Viewing 15 posts - 1 through 15 (of 18 total)
After receiving the newsletter for about 13 years, I unsubscribed today.
July 8, 2013 at 2:39 am
I see no improvement for the readers ... looks like it was done to improve ad placement, i.e. the narrow width and, hence, longer page length to accommodate ads. ...
July 5, 2013 at 3:54 am
Excellent! I'm looking forward to the follow-on articles.
June 26, 2013 at 5:38 am
... here's a stab at it:
SELECT DISTINCT
COALESCE(b.ID, a.ID), COALESCE(b.RowNo, a.RowNo), COALESCE(b.Value, a.Value)
FROM #Test1 a FULL OUTER JOIN
#Test2 b
ON a.ID = b.ID
AND b.RowNo IS NOT NULL
ORDER BY
1,2
It may be all wrong ...
April 3, 2013 at 6:35 am
David is absolutely 10% correct.
The "hazard" is given here:
"Hastily, we consult MSDN"
and
"A quick scan of the article"
and
"Obviously this must be the ticket, so let’s give that a try"
Phil...
April 3, 2013 at 3:47 am
Why do I get the feeling you enjoyed that?
I didn't really ... because I now have to stick my neck out, and put up or shut up on the...
August 6, 2012 at 12:01 pm
CROSS APPLY (
VALUES ('Revenue', JanRev, FebRev, MarRev, AprRev, MayRev, JunRev
, JulRev, AugRev,...
August 6, 2012 at 3:26 am
I'm not sure I'd agree with you on which is more maintainable.
... May we see a "full year" version of the cross apply? Then we'll start adding years...
August 3, 2012 at 2:20 am
Good to know ... I was unawares.
Here's the last example done with pivot/unpivot ... a bit more code, performance not as good ... but much more maintainable/flexible (IMO) given the...
August 2, 2012 at 2:55 pm
Maybe this to account for signs . . .
EXP(SUM(LOG(ABS([RowValue])))) * SIGN(CHECKSUM_AGG([RowValue]))
February 6, 2012 at 1:01 am
Good info . . . thanks!
April 23, 2011 at 5:34 am
Though dated a little, this thread is the closet to my project I've been able find. Any more info/progress to report?
March 28, 2011 at 10:41 am
Really . . . another ridiculous article! I am responding to this reader's reply to illustrate the problem. Misinformation breeds misinformation . . . STR is deterministic!!!!!!!!!!!!!!!!!! ...
January 9, 2011 at 6:55 am
The article's title/subtitles and other wording imply ISNUMERIC does not work properly. Here's a better way to explain the issue:
http://www.simple-talk.com/community/blogs/johnm/archive/2009/06/11/73729.aspx
December 7, 2010 at 11:14 am
The issue is ISNUMERIC returns true for values which are valid numeric data types and are not "only numeric digits" (look at the article intro again). I suppose "-1"...
December 7, 2010 at 10:26 am
Viewing 15 posts - 1 through 15 (of 18 total)