Viewing 15 posts - 5,986 through 6,000 (of 9,399 total)
Here's another approach that eliminates the REVERSE, but uses Jeff's DelimitedSplit8K function to pull the last two items from the list. Since you say it'll always be there but...
May 27, 2015 at 5:46 am
Koen Verbeeck (5/27/2015)
Easy one. Been bitten by integer division many, many times.
Agreed on both points. Integer division can also be used to your advantage, but that article isn't published...
May 27, 2015 at 5:34 am
crookj (5/26/2015)
Revenant (5/26/2015)
SQLRNNR (5/26/2015)
Ed Wagner (5/26/2015)
SQLRNNR (5/26/2015)
psychedelicPink Floyd
Wall
Brick
House
Hospital
May 26, 2015 at 10:10 am
Eirikur Eiriksson (5/26/2015)
crookj (5/26/2015)
Ed Wagner (5/26/2015)
Eirikur Eiriksson (5/22/2015)
Revenant (5/22/2015)
SQLRNNR (5/22/2015)
psychoacousticaudio
noise
Background
Image
Spitting
Splitting
May 26, 2015 at 7:02 am
SQLRNNR (5/22/2015)
Jack Corbett (5/22/2015)
My employer just finished a renovation and...
May 26, 2015 at 7:01 am
Brandie Tarvin (5/26/2015)
Luis Cazares (5/24/2015)
Would someone be interested on helping me to proofread an article that I'm planning to submit to SQLServerCentral? It's about while loops not being evil. 😀
Wow....
May 26, 2015 at 6:54 am
spaghettidba (5/26/2015)
Steve Jones - SSC Editor (5/25/2015)
Jeff Moden (5/25/2015)
TomThomson (5/23/2015)
LinksUp (5/23/2015)
May 26, 2015 at 6:52 am
I'm surprised at only 74% correct.
Happy Memorial Day to all our Veterans.
May 26, 2015 at 5:04 am
Eirikur Eiriksson (5/22/2015)
Revenant (5/22/2015)
SQLRNNR (5/22/2015)
psychoacousticaudio
noise
Background
May 26, 2015 at 4:58 am
Jason A. Long (5/21/2015)
Ed Wagner (5/21/2015)
Jason A. Long (5/21/2015)
MikeTomkies (5/21/2015)
May 25, 2015 at 7:08 pm
Jason A. Long (5/21/2015)
MikeTomkies (5/21/2015)
May 21, 2015 at 12:49 pm
Luis Cazares (5/21/2015)
I find your solution overcomplicated. This was my original approach.
--Using Jason's sample data
SELECT Part,
(ItemNumber + 1) / 2 AS SEQ,
MAX(...
May 21, 2015 at 11:44 am
DonlSimpson (5/21/2015)
cunningham (5/21/2015)
Ed Wagner (5/21/2015)
Stuart Davies (5/21/2015)
crookj (5/21/2015)
Revenant (5/21/2015)
Ed Wagner (5/21/2015)
parsonshenri (5/21/2015)
Mental blockHead
Master
Key
Stone
Rock
Roll
Jelly
Doughnuts
May 21, 2015 at 10:52 am
Viewing 15 posts - 5,986 through 6,000 (of 9,399 total)