Viewing 15 posts - 601 through 615 (of 1,248 total)
BL0B_EATER (9/17/2015)
Eirikur Eiriksson (9/17/2015)
anthony.green (9/17/2015)
Eirikur Eiriksson (9/16/2015)
Revenant (9/16/2015)
Ed Wagner (9/16/2015)
SQLRNNR (9/16/2015)
venomSnake
Eden
Utopia
Dystopia
Inferno
Heat
Hot
September 17, 2015 at 3:17 am
CREATE TABLE #weekdays
(
datevalue datetime NOT NULL
, numericvalue INT NOT NULL
);
INSERT INTO #weekdays (datevalue, numericvalue) VALUES
('2015-09-01', 1000),
('2015-09-02', 1001),
('2015-09-07', 1003),
('2015-09-08', 1004),
('2015-09-12', 1005),
('2015-09-13', 1006),
('2015-09-14', 1007),
('2015-09-19', 1008)
select
case DATEPART(dw,datevalue)
when 7 then DATEPART(wk,datevalue) +1...
September 17, 2015 at 2:57 am
kbab95 (9/17/2015)
I am trying to get the maximum for stores where there exists more than one in the same region (e.g. top sales).
I want to leave the ones where there...
September 17, 2015 at 1:39 am
whereisSQL? (9/15/2015)
Ray K (9/15/2015)
Ed Wagner (9/15/2015)
Eirikur Eiriksson (9/15/2015)
djj (9/15/2015)
Ed Wagner (9/15/2015)
anthony.green (9/15/2015)
Ed Wagner (9/14/2015)
InspireEureka
Vacuum
tube
Commute
Traffic
Jam
Jelly
Roll
September 15, 2015 at 7:36 am
Please tell me it's not just me who saw the title of today's editorial and immediately replied mentally with 'yes, you're a good developer.'
Must.Grow.Up
September 15, 2015 at 2:38 am
rodjkidd (9/15/2015)
BWFC (9/15/2015)
rodjkidd (9/14/2015)
BWFC (9/11/2015)
BWFC (9/11/2015)
September 15, 2015 at 2:33 am
rodjkidd (9/14/2015)
BWFC (9/11/2015)
BWFC (9/11/2015)
September 15, 2015 at 1:45 am
Reported as spam
September 14, 2015 at 3:30 am
BWFC (9/11/2015)
September 11, 2015 at 7:03 am
BL0B_EATER (9/11/2015)
Ed Wagner (9/11/2015)
Alvin Ramard (9/10/2015)
Lynn Pettis (9/10/2015)
Alvin Ramard (9/10/2015)
Lynn Pettis (9/10/2015)
September 11, 2015 at 6:36 am
Ed Wagner (9/11/2015)
Eirikur Eiriksson (9/11/2015)
anthony.green (9/11/2015)
whereisSQL? (9/10/2015)
Ed Wagner (9/10/2015)
DonlSimpson (9/10/2015)
Ed Wagner (9/10/2015)
djj (9/10/2015)
Ed Wagner (9/10/2015)
whereisSQL? (9/10/2015)
Luis Cazares (9/10/2015)
UniverseHe-Man
Conan
Sword
Katana
Samurai
Shogun
Shaolin
Monastery
Hermetic
Seal
Wax
September 11, 2015 at 5:46 am
Does anybody know if SQL Relay Huddersfield is still going ahead? I had an email this morning and it wasn't listed as one of the venues. It's still...
September 11, 2015 at 2:04 am
Eirikur Eiriksson (9/10/2015)
Stuart Davies (9/10/2015)
Ed Wagner (9/9/2015)
djj (9/9/2015)
Ed Wagner (9/9/2015)
DonlSimpson (9/9/2015)
Luis Cazares (9/9/2015)
Ed Wagner (9/9/2015)
crookj (9/9/2015)
Jim_K (9/9/2015)
ZZartin (9/9/2015)
eccentricDBA (9/9/2015)
BWFC (9/9/2015)
Eirikur Eiriksson (9/9/2015)
whereisSQL? (9/9/2015)
ClassyGlossy
Magazine
cartridge
Cartilage
Shark
Jaws
Sea
World
Globe
Travel
Lodge
Cast Iron
guarantee
Warranty
Extended
September 10, 2015 at 12:53 am
Eirikur Eiriksson (9/9/2015)
whereisSQL? (9/9/2015)
ClassyGlossy
Magazine
September 9, 2015 at 8:31 am
andrew gothard (9/9/2015)
BWFC (9/8/2015)
A correctly formed postcode can be 7 or 8 characters - eg SW1A 4WW so change RIGHT(PostalCode, 7) to RIGHT(PostalCode, 8) and LTRIM the result
Postcodes can be...
September 9, 2015 at 3:23 am
Viewing 15 posts - 601 through 615 (of 1,248 total)