skip to main
|
skip to sidebar
Random technical stuff
Don't expect romance, you only get computing here.
Wednesday, September 15, 2010
Poor man's LAG() and LEAD()
How to do LAG() and LEAD() in
SQL Server 2008
.
0 comments:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
Blog Archive
►
2011
(2)
►
February
(1)
How to use NUnit in Visual Studio 2010
►
January
(1)
What does Vodafone 3G and the Sydney city bus syst...
▼
2010
(27)
►
December
(4)
My greatest claim to fame
Markov Chain generator
Sargability of monotonic functions in SQL
SQL Server Management Studio 2008 R2
►
October
(4)
Sequence tables in SQL Server 2005
Mistake in Wikipedia article on the Builder patter...
ICloneable: Microsoft's big mistake
SQL Server indexing...
▼
September
(2)
Poor man's LAG() and LEAD()
Recursive queries vs. nonrecursive queries; and co...
►
August
(6)
My app in Ubuntu crashed, but I didn't have debugs...
Active Directory trusts
For posterity
Pearson Product Moment Correlation Coefficient
And down the rabbit hole I go...
Undocumented optimizer feature in SQL Server 2005/...
►
July
(4)
Wow, I got that wrong!
How to debug segfaults in Ubuntu
Dora!
True geek heaven!
►
June
(2)
Yay powersets!
Java classpath issues
►
May
(3)
Youtube clips I have posted to my Facebook profile...
Cross browser code
Giano quote file
►
April
(1)
Running total in SQL Server...
►
March
(1)
How many members should be in the Australian House...
►
2009
(36)
►
November
(1)
Nasty Oracle ADO bug
►
October
(3)
Great story
Planet Gnome
Evil... but totally cool. Debugging apps remotely ...
►
August
(4)
List of query processing errors in SQL Server 2005...
Note to myself
Well here's something new...
Guaranteeing order in views
►
July
(2)
Interesting!
Bah, humbug
►
June
(4)
Bwhahahaha!!!!
Apple story
Hell just froze over
Last.fm
►
May
(7)
"UAC elevations are not 'security'"
Excellent post of SSDs
Method 2's a bit of winner.
New storage book
Oracle Dump() statement
Unicode and Oracle
Finding what font renders Unicode characters in th...
►
March
(1)
►
February
(7)
►
January
(7)
►
2008
(6)
►
December
(6)
Labels
3
3g
activedirectory
ado
algorithm
apple
applehater
ascii
asshat
australia
baby
bah
bash
book
boundaryconditionfailure
bug
c
charactersets
classpath
coffee
compiler
congestion
conspicuousconsumption
coolhack
crazypeople
css
cutie
damn
databases
dbcs
debian
debugging
denialofservice
designpatterns
dontdothisathome
dora
dotnet
dvorak
ecma
email
emc
facebook
fail
failagain
firefox
fonts
forkbomb
freebooks
freescale
futurama
gcc
gdb
gnome
grammar
green
hellfreezesover
humour
idleprocess
interfaces
irc
iso
japanese
java
johncdvorak
joins
kfc
knuth
letterman
linux
linuxandmicrosoft
markovchain
math
memory
microsoft
montypython
mousedenier
music
nbn
nerds
networking
notestomyself
nunit
oops
oracle
oxymoron
perfmon
pointless
powerset
printer
pronounspronounspronouns
pua
queries
rbar
reminder
reply-all
richardsimmons
security
segfault
sequencetables
services
sets
slashdot
slate
sound
spam
sql
sqlite3
sqlserver2005
sqlserver2008
ssds
statistics
steamers
stevejobs
storage
stupidnettricks
supportgonemad
suv
technicalwriting
tuning
twitter
uac
ubuntu
unicode
varchar(max)
visualstudio2010
vodafone
warnings
webbrowers
wikipedia
windows
windowsvista
windowsxp
windowsxphater
xssflaw
youtube
zune
℘
0 comments:
Post a Comment