Viewing 15 posts - 76 through 90 (of 218 total)
Ed Wagner (6/17/2015)
Eirikur Eiriksson (6/17/2015)
Ed Wagner (6/17/2015)
Revenant (6/17/2015)
Ed Wagner (6/17/2015)
crookj (6/17/2015)
DonlSimpson (6/17/2015)
djj (6/17/2015)
Ed Wagner (6/17/2015)
djj (6/17/2015)
Ed Wagner (6/17/2015)
Eirikur Eiriksson (6/17/2015)
ChocolateDark
Light
Sabre
Tooth
Tiger (I don't think I had a choice)
Woods
Hunting
Egg
Omlet
Allium sativum
Garlic (Had to...
June 17, 2015 at 2:41 pm
Eirikur Eiriksson (6/11/2015)
Ed Wagner (6/11/2015)
crookj (6/11/2015)
ZZartin (6/11/2015)
BottleRum
Running
quirky
Qt
June 11, 2015 at 11:57 am
djj (6/11/2015)
Ed Wagner (6/11/2015)
crookj (6/11/2015)
Ed Wagner (6/11/2015)
djj (6/11/2015)
Stuart Davies (6/11/2015)
BL0B_EATER (6/11/2015)
Ed Wagner (6/10/2015)
Eirikur Eiriksson (6/10/2015)
Ed Wagner (6/10/2015)
ZZartin (6/10/2015)
Manic Star (6/10/2015)
Ed Wagner (6/10/2015)
Eirikur Eiriksson (6/10/2015)
crookj (6/10/2015)
ZombieWorker
Oxymoron
brain
bureaucrat
Inefficient
Cursor
Set
Theory
everything
42 (I had to)
Life
Reincarnation
Rewrite
Typo
Syntax
June 11, 2015 at 8:08 am
andrew_dale (6/10/2015)
the function ABS(CHECKSUM(NEWID()) % 100) is being treated as a field even though it is not in the select list
Each row gets a value (may...
June 10, 2015 at 10:48 am
andrew_dale (6/10/2015)
So how does ORDER BY 79 actually...
June 10, 2015 at 4:33 am
David in .AU (6/9/2015)
A bit of fun.Question:
Since I assume the computer your SQL Server is on has a network card, why not just order by newid()?
Yes the newid() would have...
June 10, 2015 at 4:26 am
Eirikur Eiriksson (6/9/2015)
Ed Wagner (6/9/2015)
djj (6/9/2015)
Eirikur Eiriksson (6/8/2015)
Ed Wagner (6/8/2015)
crookj (6/8/2015)
Ed Wagner (6/8/2015)
Revenant (6/8/2015)
DonlSimpson (6/8/2015)
Ed Wagner (6/8/2015)
djj (6/8/2015)
Ed Wagner (6/8/2015)
DonlSimpson (6/5/2015)
Eirikur Eiriksson (6/5/2015)
MonarchyEmpire
Republic
Plato
Socrates
Philosopher
Academy
Starfleet
KDF
Bird of Prey
Specialization
Specific
General
Generations
X
June 9, 2015 at 12:02 pm
Yes.
The NEWID() generates a random GUID. Then we do a checksum on against the GUID to get us integer value. Next we do a modulo operation to get the...
June 9, 2015 at 11:48 am
whereisSQL? (5/29/2015)
hughmanning (5/29/2015)
ArtificalIntelligence
research
May 29, 2015 at 12:33 pm
Eirikur Eiriksson (5/14/2015)
Revenant (5/14/2015)
Ed Wagner (5/14/2015)
crookj (5/14/2015)
Ed Wagner (5/14/2015)
djj (5/14/2015)
Ed Wagner (5/13/2015)
SQLRNNR (5/13/2015)
djj (5/12/2015)
Ed Wagner (5/12/2015)
Revenant (5/12/2015)
SQLRNNR (5/12/2015)
djj (5/12/2015)
BWFC (5/12/2015)
SQLRNNR (5/12/2015)
whereisSQL? (5/12/2015)
BWFC (5/12/2015)
Intelligence
Business
Oxymoron
Subjective
Objective
Lens
Magnify
Quantify
Numbers
Meaning
Life
Curly (City Slickers)
Cowboy
Steer
Tenderloin
Tipping (cow)
Canoe
Canada
Caesium
Pollucite
May 14, 2015 at 12:03 pm
djj (4/30/2015)
Revenant (4/30/2015)
Ed Wagner (4/30/2015)
eccentricDBA (4/30/2015)
Ed Wagner (4/30/2015)
Revenant (4/30/2015)
crookj (4/30/2015)
Ed Wagner (4/30/2015)
SQLRNNR (4/29/2015)
Revenant (4/29/2015)
Ed Wagner (4/29/2015)
Eirikur Eiriksson (4/29/2015)
Stuart Davies (4/29/2015)
Eirikur Eiriksson (4/28/2015)
Ed Wagner (4/28/2015)
TomThomson (4/28/2015)
crookj (4/28/2015)
Ed Wagner (4/28/2015)
Revenant (4/28/2015)
SQLRNNR (4/28/2015)
TomThomson...
April 30, 2015 at 2:59 pm
Ed Wagner (4/30/2015)
Revenant (4/30/2015)
crookj (4/30/2015)
Ed Wagner (4/30/2015)
SQLRNNR (4/29/2015)
Revenant (4/29/2015)
Ed Wagner (4/29/2015)
Eirikur Eiriksson (4/29/2015)
Stuart Davies (4/29/2015)
Eirikur Eiriksson (4/28/2015)
Ed Wagner (4/28/2015)
TomThomson (4/28/2015)
crookj (4/28/2015)
Ed Wagner (4/28/2015)
Revenant (4/28/2015)
SQLRNNR (4/28/2015)
TomThomson (4/27/2015)
SQLRNNR (4/27/2015)
marlinspike
hall
fame
Fortune
Teller
Automatic
Tommy
Gun
Smoke
Mirrors
Reflect
surface
Pro 4
Amateur
Slapdash
Irresponsible
Management
Risk
April 30, 2015 at 1:01 pm
SQLRNNR (4/27/2015)
marlin
Brando (his fishy cousin)
April 27, 2015 at 12:03 pm
Ed Wagner (4/23/2015)
Revenant (4/23/2015)
djj (4/23/2015)
Eirikur Eiriksson (4/23/2015)
Ed Wagner (4/23/2015)
djj (4/23/2015)
TomThomson (4/22/2015)
Eirikur Eiriksson (4/22/2015)
djj (4/22/2015)
Eirikur Eiriksson (4/21/2015)
SQLRNNR (4/21/2015)
fecal fabric flinging fairiesPixie Dust
Neverland
Dragons
Dungeons
Master
Game
Theory
Relativity
Time
Travel
Dimension
April 23, 2015 at 11:12 am
Eirikur Eiriksson (4/21/2015)
Ed Wagner (4/21/2015)
Eirikur Eiriksson (4/21/2015)
SQLRNNR (4/21/2015)
faintdistant
Far
Fetched
idea
April 21, 2015 at 11:07 am
Viewing 15 posts - 76 through 90 (of 218 total)