Vladan, check your code... I don't believe it's coming up with the correct result set. 😉

You can use a While loop if you want... but I wouldn't... 😉 See the following...

http://www.sqlservercentral.com/articles/T-SQL/63003/

ammarghanem921 (1/31/2009)

---

Hi all

I do have One stored procedure that calls other stored procedures, each on which might call another stored procedure. However, am making begin transaction, commit transaction and...

Isn't there something missing from that JOIN? Like a table or somthing and an equation?

RBarryYoung (1/31/2009)

---

Heh. You know Jeff, I think that this might change that article that you're writing, just a little bit. I bet you don't mind too much though....

Jeff Moden (1/31/2009)

---

RBarryYoung (1/31/2009)

---

For Stephen or anybody else who may be interested, here is a previous thread where Jeff, andrewd.smith, myself and others discuss the finer points of Latitude/Longitude calculations...

RBarryYoung (1/31/2009)

---

For Stephen or anybody else who may be interested, here is a previous thread where Jeff, andrewd.smith, myself and others discuss the finer points of Latitude/Longitude calculations and searchs...

On that note, all I can do

is raise my mug into the air

and say "3 cheers to SSC"

and to all of those that care! 😀

I ran into an interesting article... glad to see that "big money" hasn't changed Steve a bit since then except that he continues to just keep making it better and...

Heh... "Don't use undocumented features"... as opposed to what? Using just the documented ones? You mean like the wonderful and heavily documented sp_MakeWebTask whose required privs changed overnight...

It depends on whether or not you believe in the myth of portable code. TOP is an SQL Server manifestation.

Other than that, "best", in my book, is the one...

Heh... Barry graduated from the school of "Right Now" and teaches from the good book of "Boy Howdy!" 😛

I'm a bit thick on...

Ok... coming full circle back to Martin's original problem...

Here's the test data...

USE TempDb --Just a safe place to run things

GO

--DROP TABLE dbo.YourTable

GO

--===== Populate the test table...

By the way... if anyone else wants to study the code, the original "puzzle" question and two sets of data are available at the following URL...

http://www.sqlmag.com/article/articleid/93462/sql_server_blog_93462.html

... and like I've done...