Finding previous record based on a single common field.

Question

Post reply

Finding previous record based on a single common field.

Forum Etiquette: How to post Reporting Services problems

[/url]

Forum Etiquette: How to post data/code on a forum to get the best help - by Jeff Moden
[/url]

How to Post Performance Problems - by Gail Shaw
[/url]

Thomw SSC-Addicted Points: 453 More actions · Answer 1

aahhh... Got it. thanks for answering the n00b question.:-)

--
"The weakness of thinking machines is that they actually believe all the information they receive, and react accordingly." Vorian Atreides
(Brian Herbert and Kevin J. Anderson)

WayneS SSC Guru Points: 95460 More actions · Answer 2

mister.magoo (4/23/2010)
Here you go...Wayne had it just about right, but missed the sort order reversal required...

mister.magoo, thanks for catching this.

Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes

If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!

Links:
For better assistance in answering your questions
Performance Problems
Common date/time routines
Understanding and Using APPLY Part 1 & Part 2

mister.magoo SSC-Forever Points: 47174 More actions · Answer 3

WayneS (4/26/2010)
mister.magoo (4/23/2010)
Here you go...Wayne had it just about right, but missed the sort order reversal required...
mister.magoo, thanks for catching this.

You know what, checking back (because it was niggling away at me anyway) I realise it was my initial answer that had the wrong sort order, so I apologise for making it seem like you had got it wrong. It was my mistake, not yours.

MM

select geometry::STGeomFromWKB(0x0106000000020000000103000000010000000B0000001000000000000840000000000000003DD8CCCCCCCCCC0840000000000000003DD8CCCCCCCCCC08408014AE47E17AFC3F040000000000104000CDCCCCCCCCEC3F9C999999999913408014AE47E17AFC3F9C99999999991340000000000000003D0000000000001440000000000000003D000000000000144000000000000000400400000000001040000000000000F03F100000000000084000000000000000401000000000000840000000000000003D0103000000010000000B000000000000000000143D000000000000003D009E99999999B93F000000000000003D009E99999999B93F8014AE47E17AFC3F400000000000F03F00CDCCCCCCCCEC3FA06666666666FE3F8014AE47E17AFC3FA06666666666FE3F000000000000003D1800000000000040000000000000003D18000000000000400000000000000040400000000000F03F000000000000F03F000000000000143D0000000000000040000000000000143D000000000000003D, 0);