Probably the best advice I can give you is that you should.

The result here is going to be highly dependent on the indexing available on the...

Assuming your "tree" is an adjacency list, traversing down is nearly the same as traversing up.

So, is this something like what you want?

WITH SampleData (parent, child) AS

(

SELECT 1,2

UNION ALL SELECT...

Coincidentally I just now ran across a quite interesting article on this subject by Erland Sommerskog in his blog and since I didn't see anyone post that link here, I...

marko.celarc (2/5/2015)

---

insert into dbo.history_table

(ItemId, Oid, old_value, new_value, TransactionCode)

select

ItemId, 18, old_value, new_Value, '1234567'

from

(

merge into

dbo.mother_table AS target_table

using

(select

itemNo,

1057

from

dbo.some_table

where

something = 3) as source_table (ItemNo, new_stat)

on

(target_table.some_field = source_table.ItemNo)

when...

KGJ-Dev (2/9/2015)

---

Hi Dwain,

thanks and i tried to understand the geography data type and i am trying to add new column in my table with geography datatype.

alter table Zipcode...

KGJ-Dev (2/9/2015)

---

but how do i can search my table based on this 20 mile radius and how this function will be useful to me as i already know what radius...

KGJ-Dev (2/9/2015)

---

Yes Dwain, Is the below one you are asking?

CREATE FUNCTION HaversineDistance

(@OriginLat FLOAT

,@OriginLong FLOAT

...

KGJ-Dev (2/9/2015)

---

Hi Dwain,

thanks for your reply and i gone through link. Really it's very high level and am struggling how do i correlate that with my requirement. If possible could...

Luis Cazares (2/9/2015)

---

And France is divided in regions, departments, arrondisements, cantons, communes and, in some cases, municipal arrondissements.

I'm sure that...

This is interesting, but I have no idea how complete/current it is:

https://raw.githubusercontent.com/yosoyadri/GeoNames-XML-Builder/master/continents-countries-statesprovinces.xml

There's an iTVF form of Haversine function here:

Departures from Origins and Arrivals at Destinations[/url]

Note that this method of haversine does not take into account adjusted curvature of the Earth.

Many countries don't call them states, they call them provinces.

Having said that, if you find one I too would be interested. But aside from scraping them off the wiki...

Luis Cazares (12/15/2014)

---

This is an idea on how to do it. It's not perfect as the NULLS will be sorted first. I'm sure that you'll be able to handle that.

DECLARE...

It is possible to avoid multiple scans of your table if you know there are only 3 groups and you don't care about machines that are missing all of them.

SELECT...

Out of curiosity, is the SP equipped to handle the case where there are multiple rows in the @employee table you pass into it?

Normally I would have used separate parameters...