Viewing 15 posts - 1,186 through 1,200 (of 1,249 total)
No, I mean the difference in row counts between the procedure and view, the problem that we're trying to solve.
Of course you did, sorry, conference call brain fry.
There is no...
January 31, 2014 at 6:11 am
GilaMonster (1/31/2014)
Can't see anything obvious (other than multiple unnecessary DISTINCTs)Is the difference in rowcount consistent?
If you mean 'is the difference in ServiceDays and AverageServiceDays the same every time' then yes....
January 31, 2014 at 4:25 am
Fair enough, although I'm a little hurt you don't trust me.... 🙂
The code to create the dashboard with the proc
set transaction isolation level read uncommitted
set dateformat ymd
select distinct
OrderType =
case...
January 31, 2014 at 3:41 am
I've attached the code now. I've had to do a bit of obfuscation, which I hope doesn't hide the logic. The organisation I work for is quite high...
January 31, 2014 at 3:29 am
Kurt W. Zimmerman (1/28/2014)
Ed Wagner (1/28/2014)
L' Eomot Inversé (1/28/2014)
crookj (1/28/2014)
Ed Wagner (1/28/2014)
BWFC (1/28/2014)
DrinkRestaurant
Jocko's Steak House
Rib Eye Steak
Medium rare
à point
Blue
January 29, 2014 at 1:32 am
L' Eomot Inversé (1/24/2014)
Ed Wagner (1/23/2014)
BWFC (1/23/2014)
JAZZ Master (1/22/2014)
Revenant (1/22/2014)
Ed Wagner (1/22/2014)
SQLRNNR (1/22/2014)
simCity
bestseller
novel
New
Clean
Sterile
Aseptic
January 27, 2014 at 2:02 am
Hi Sean
I've had a tinker with my proc and using the CTE approach works just as quickly as temp tables when using my method to create the combined column. ...
January 24, 2014 at 4:14 am
Thanks Sean. I did try using CTE's when I was testing but oh boy did it slow down. I'd forgotten about STUFF, I'm very new to SQL and...
January 23, 2014 at 8:14 am
JAZZ Master (1/22/2014)
Revenant (1/22/2014)
Ed Wagner (1/22/2014)
SQLRNNR (1/22/2014)
simCity
bestseller
novel
New
January 23, 2014 at 1:18 am
Ed Wagner (1/17/2014)
OCTom (1/17/2014)
SQLRNNR (1/17/2014)
Rockfordfiles
Paths
Roads
January 20, 2014 at 1:25 am
Ed Wagner (1/16/2014)
SQLRNNR (1/16/2014)
JAZZ Master (1/16/2014)
Revenant (1/16/2014)
sing4you (1/16/2014)
crookj (1/16/2014)
Ed Wagner (1/16/2014)
SQLRNNR (1/16/2014)
Ed Wagner (1/16/2014)
BWFC (1/16/2014)
Ed Wagner (1/15/2014)
crookj (1/15/2014)
WOTD - bletcherousCode
Bloat
Fix (as in make efficient)
diet
Coke
Soda
Scotch
naked (as in 'We Scots like...
January 17, 2014 at 1:14 am
Ed Wagner (1/15/2014)
crookj (1/15/2014)
WOTD - bletcherousCode
Bloat
January 16, 2014 at 1:02 am
Ed Wagner (1/10/2014)
SQLRNNR (1/10/2014)
the bodyThe mind
Matter
January 13, 2014 at 1:18 am
Ed Wagner (1/10/2014)
sing4you (1/10/2014)
Ed Wagner (1/10/2014)
crookj (1/10/2014)
Ed Wagner (1/10/2014)
SQLRNNR (1/9/2014)
Kurt W. Zimmerman (1/9/2014)
Revenant (1/9/2014)
whereisSQL? (1/9/2014)
crookj (1/9/2014)
WOTD - TautologicalRedundant
fail-safe
dead-man
walking
Running
Man
Terminator
Governator
Jesse Ventura
Boulevard
January 10, 2014 at 7:56 am
Viewing 15 posts - 1,186 through 1,200 (of 1,249 total)