Viewing 15 posts - 1,381 through 1,395 (of 1,988 total)
You can put a case statement in the order by, so something like for the order by.
ORDER BY
case when [No Of Applications] = '1' then 1
when [No Of Applications]...
April 14, 2016 at 8:24 am
crookj (4/14/2016)
Ed Wagner (4/14/2016)
ThomasRushton (4/14/2016)
Grumpy DBA (4/14/2016)
djj (4/14/2016)
ArmorUnder
Ground
Overground
Wombling free
Secret
Identity
Crisis
April 14, 2016 at 8:09 am
Something else to consider is whether you want to work for a company that hires someone just to meet an arbitrary deadline, if you're worried about competition then by all...
April 13, 2016 at 10:50 am
Steve Jones - SSC Editor (4/13/2016)
April 13, 2016 at 8:20 am
It really depends on the company and the recruiter, some companies have recruiters they trust to understand their requirements and not jerk them around when sending them candidates.
April 12, 2016 at 1:34 pm
whereisSQL? (4/12/2016)
jeff.mason (4/12/2016)
Manic Star (4/12/2016)
Ray K (4/12/2016)
DonlSimpson (4/12/2016)
Ed Wagner (4/12/2016)
whereisSQL? (4/12/2016)
Ed Wagner (4/12/2016)
BWFC (4/12/2016)
ThomasRushton (4/12/2016)
Revenant (4/12/2016)
ThomasRushton (4/12/2016)
Manic Star (4/12/2016)
whereisSQL? (4/12/2016)
djj (4/12/2016)
Grumpy DBA (4/12/2016)
Ed Wagner (4/12/2016)
San Francisco(left my) Heart
Soul
Train
Tracks
switch
blade
glory
Blaze
Fire
Fighter
Mortal Combat
Arcade
Pac-Man
Nom Nom...
April 12, 2016 at 11:33 am
Maybe at some point there was an actual value for the ISNULL and instead of just removing the ISNULL they changed to to NULL?
April 11, 2016 at 1:42 pm
Ed Wagner (4/11/2016)
Ray K (4/11/2016)
Revenant (4/11/2016)
Grumpy DBA (4/11/2016)
ThomasRushton (4/11/2016)
HighlanderToyota
Hybrid
RAV4
Accord
Peace
April 11, 2016 at 10:23 am
The other thing to keep in mind is that in large metropolitan areas the quality of public services can vary vastly over a very short distance, for example police showing...
April 11, 2016 at 8:27 am
Jeff Moden (4/10/2016)
April 11, 2016 at 2:23 am
That's the kind of interview question that would make me wonder whether the interviewer knows what they're talking about or not. Technically any query with any kind of filtering...
April 8, 2016 at 1:57 pm
ThomasRushton (4/8/2016)
DonlSimpson (4/8/2016)
crookj (4/8/2016)
Ed Wagner (4/8/2016)
Revenant (4/8/2016)
ThomasRushton (4/8/2016)
Ed Wagner (4/8/2016)
Manic Star (4/8/2016)
Luis Cazares (4/8/2016)
crookj (4/8/2016)
Ed Wagner (4/8/2016)
TomThomson (4/8/2016)
Ed Wagner (4/8/2016)
Pork ChopKarate Pig
Kung Fu Panda
Splinter (Kung Fu Rat)
TMNT
Dynamite
Nobel
Peace
Peas
Split
Anderson's (World famous split...
April 8, 2016 at 9:21 am
I don't see the problem so much as storing blob data regardless of what it is but when people want to try to parse it in SQL Server in bulk.....
April 8, 2016 at 9:20 am
Naming conventions are weird, as long as they're consistent I can live with them though. My favorite was working with an open source esales database developed by a company...
April 7, 2016 at 9:13 am
What criteria are you using to generate the desired result set? It looks like it doesn't include employee no on every row.
April 6, 2016 at 2:01 pm
Viewing 15 posts - 1,381 through 1,395 (of 1,988 total)