Viewing 15 posts - 571 through 585 (of 6,486 total)
Steve Jones - SSC Editor (1/6/2015)
Matt Miller (#4) (1/6/2015)
It's the classic misinterpreting of the data: even qualified individuals fall into the trap so amateurs (e.g. HR) will more likely...
January 6, 2015 at 4:12 pm
Steve Jones - SSC Editor (1/6/2015)
jay-h (1/6/2015)
It makes little difference whether it's the insurance company or the employer doing it. Essentially financial leverage is pressuring invasion of private lives. It...
January 6, 2015 at 1:03 pm
Andy Warren (1/5/2015)
January 5, 2015 at 11:13 am
jay-h (1/5/2015)
Iwas Bornready (1/5/2015)
January 5, 2015 at 10:31 am
Perhaps I am blessed, but I am making more as an employee now than I did as a consultant and am doing things I fundamentally enjoy. It's not to...
January 5, 2015 at 8:15 am
I am feeling silly. There's a much simpler implementation, but I basically never use this function.
The trick is to leverage the NTILE aggregate function rather than ROW_NUMBER. In...
December 17, 2014 at 1:32 pm
djj (12/17/2014)
Matt Miller (#4) (12/17/2014)
Since you're trying to get a groups bottomo 25% - I think you're looking at...
December 17, 2014 at 1:23 pm
Ed Wagner (12/17/2014)
Grant Fritchey (12/17/2014)
WayneS (12/17/2014)
Jeff Moden (12/17/2014)
Koen Verbeeck (12/17/2014)
Brandie Tarvin (12/17/2014)
Brandie Tarvin (12/16/2014)
I just spent 2 & 1/2 days reworking a package and its supporting tables / stored...
December 17, 2014 at 12:01 pm
All right - the requirement is a bit different than initially read.
Since you're trying to get a groups bottomo 25% - I think you're looking at something like the following:
with...
December 17, 2014 at 11:43 am
djj (12/16/2014)
Marcus Farrugia (12/16/2014)
IF OBJECT_ID('TempDB..#mytable','U') IS NOT NULL
...
December 17, 2014 at 11:25 am
Gary Varga (12/12/2014)
December 12, 2014 at 9:47 am
sqldriver (12/9/2014)
Grant Fritchey (12/9/2014)
doesn't everything in sql server? 😉
Still trying to figure out what the use-case for multi-statement table-valued user-defined functions is. But, other than that, yes!
Their one...
December 10, 2014 at 11:03 am
Ed Wagner (12/10/2014)
December 10, 2014 at 7:32 am
As much as I see the issue blandry brought up continuously these days - it's really not about "human judgment", but about personal skills. Not having those basic skills...
December 8, 2014 at 2:12 pm
Not where I thought this would go, but hey - they're YOUR christmas cards.
As to the question - I was 8 at the time that stunt was published, though...
December 8, 2014 at 8:28 am
Viewing 15 posts - 571 through 585 (of 6,486 total)