Hugo Kornelis (7/1/2015)

---

Also - relationships do not exist in a relational database. Relationships exist in a relational design.

Ed Wagner (7/1/2015)

---

djj (7/1/2015)

---

psingla (7/1/2015)

---

Ed Wagner (7/1/2015)

---

BL0B_EATER (7/1/2015)

---

Ed Wagner (6/30/2015)

---

Eirikur Eiriksson (6/30/2015)

---

crookj (6/30/2015)

---

Ed Wagner (6/30/2015)

---

djj (6/30/2015)

---

Ed Wagner (6/30/2015)

---

ZZartin (6/30/2015)

---

Ed Wagner (6/30/2015)

---

crookj (6/30/2015)

---

Eight

Bits

Cake

Bake

Boil

Grill

Sergeant (Sorry - really bad commercial...)

NCO

Officer

law

Lawyers

intelligible

unintelligible

Management

Ed Wagner (6/30/2015)

---

Revenant (6/30/2015)

---

crookj (6/30/2015)

---

Ed Wagner (6/30/2015)

---

djj (6/30/2015)

---

Ed Wagner (6/30/2015)

---

ZZartin (6/30/2015)

---

Ed Wagner (6/30/2015)

---

crookj (6/30/2015)

---

Eight

Bits

Cake

Bake

Boil

Grill

Sergeant (Sorry - really bad commercial...)

Drill

Power Tools 😀

Alan.B (6/30/2015)

---

Based on my testing, the function appears to perform a bit faster using CHECKSUM over ROW_NUMBER() instead of the conversion to BIGINT in the TOP clause.

http://www.sqlservercentral.com/Forums/Topic1585850-391-3.aspx

ChrisM@Work (6/30/2015)

---

Nice job, Alan.

One question: what's the CHECKSUM() for? It doesn't appear to change the result from ROW_NUMBER().

djj (6/29/2015)

---

Ed Wagner (6/29/2015)

---

psingla (6/29/2015)

---

TomThomson (6/26/2015)

---

jonathan.crawford (6/26/2015)

---

Eirikur Eiriksson (6/26/2015)

---

Ed Wagner (6/26/2015)

---

DonlSimpson (6/26/2015)

---

Ed Wagner (6/26/2015)

---

BL0B_EATER (6/26/2015)

---

BWFC (6/26/2015)

---

eccentricDBA (6/26/2015)

---

djj (6/26/2015)

---

Ed Wagner (6/26/2015)

---

Eirikur Eiriksson (6/25/2015)

---

TomThomson (6/25/2015)

---

Drink

Water

Ocean

Liner

Makeup

Breakup

Terminate

Liquid Metal

Mercury

Saturn

Orbit

Gravity

Gravitar

Aftermath

Ruins

Runes

Ed Wagner (6/26/2015)

---

BL0B_EATER (6/26/2015)

---

BWFC (6/26/2015)

---

eccentricDBA (6/26/2015)

---

djj (6/26/2015)

---

Ed Wagner (6/26/2015)

---

Eirikur Eiriksson (6/25/2015)

---

TomThomson (6/25/2015)

---

Drink

Water

Ocean

Liner

Makeup

Breakup

Terminate

Liquid Metal

whereisSQL? (6/25/2015)

---

Ed Wagner (6/25/2015)

---

Narud (6/25/2015)

---

djj (6/25/2015)

---

Ed Wagner (6/25/2015)

---

crookj (6/25/2015)

---

Stuart Davies (6/25/2015)

---

Revenant (6/25/2015)

---

Ed Wagner (6/25/2015)

---

BL0B_EATER (6/25/2015)

---

crookj (6/25/2015)

---

Ed Wagner (6/25/2015)

---

DonlSimpson (6/24/2015)

---

Ed Wagner (6/24/2015)

---

Sean Lange (6/24/2015)

---

Please!!!

More

Routing

Redirection

U-Turn

opposite

Polar

Equatorial

Forrest

AD (Active Directory)

Domain

Password

Strong

Power

Hungry

compufreak (6/24/2015)

---

i have researched and so far nothing seems to be working. There is a conflict between the FinancialYearID of the 1st and 2nd stored procs.

Ed Wagner (6/24/2015)

---

Sean Lange (6/24/2015)

---

Ed Wagner (6/24/2015)

---

djj (6/24/2015)

---

Ed Wagner (6/24/2015)

---

TomThomson (6/24/2015)

---

Ed Wagner (6/24/2015)

---

Narud (6/24/2015)

---

crookj (6/24/2015)

---

Revenant (6/24/2015)

---

Ed Wagner (6/24/2015)

---

djj (6/24/2015)

---

Ed Wagner (6/24/2015)

---

djj (6/24/2015)

---

Ed Wagner (6/24/2015)

---

DonlSimpson (6/23/2015)

---

Eirikur Eiriksson (6/23/2015)

---

crookj (6/23/2015)

---

Red

ruM

Thoroughbred

Horserace

Racetrack

Bet

Loose

Goose

Moose

Bullwinkle

Rocky

Boxing

packaging

Ship

Boat

Beer

Please!!!

More

Eirikur Eiriksson (6/23/2015)

---

crookj (6/23/2015)

---

djj (6/23/2015)

---

Ed Wagner (6/23/2015)

---

Eirikur Eiriksson (6/23/2015)

---

Ed Wagner (6/23/2015)

---

djj (6/23/2015)

---

Eirikur Eiriksson (6/23/2015)

---

Revenant (6/23/2015)

---

djj (6/23/2015)

---

Jim_K (6/23/2015)

---

djj (6/23/2015)

---

Ed Wagner (6/23/2015)

---

Eirikur Eiriksson (6/23/2015)

---

TomThomson (6/23/2015)

---

BL0B_EATER (6/23/2015)

---

SQLRNNR (6/22/2015)

---

DonlSimpson (6/5/2015)

---

---

---

---

---

Empire

Queensryche

band

elastic

Revolite

Light

Ultraviolet

electromagnetic

Railgun

Navy

Spending

Excesive

Government

Target

Range

Rover

Red

ruM

crookj (6/22/2015)

---

Ed Wagner (6/22/2015)

---

Eirikur Eiriksson (6/22/2015)

---

TomThomson (6/22/2015)

---

djj (6/22/2015)

---

Ed Wagner (6/22/2015)

---

djj (6/22/2015)

---

Ed Wagner (6/22/2015)

---

crookj (6/19/2015)

---

DonlSimpson (6/19/2015)

---

Glamdring

Olórin

Mordor

Mountain

Mole Hill

Project Mohole

failure

Lesson

Learn

Experience

eccentricDBA (6/19/2015)

---

djj (6/19/2015)

---

crookj (6/19/2015)

---

djj (6/19/2015)

---

Revenant (6/18/2015)

---

TomThomson (6/18/2015)

---

Eirikur Eiriksson (6/18/2015)

---

whereisSQL? (6/18/2015)

---

eccentricDBA (6/18/2015)

---

Ed Wagner (6/18/2015)

---

eccentricDBA (6/18/2015)

---

Revenant (6/18/2015)

---

Eirikur Eiriksson (6/18/2015)

---

eccentricDBA (6/18/2015)

---

DonlSimpson (6/18/2015)

---

crookj (6/18/2015)

---

BL0B_EATER (6/18/2015)

---

Ed Wagner (6/18/2015)

---

TomThomson (6/18/2015)

---

Revenant (6/17/2015)

---

Stupor

Dementia

Confusion

Mental

Case

Brief

discussion

Sentence

Death

transcend

Experience

Hendrix

Guitar

Recuerdos de la Alhambra

Tárrega

Classic

Car

(hot) Rod

Staff

Gandalf