Hi,

I have a scenario for which I need a solution with SQL Server 2005.

I have two tables with the following structure:

TABLE 1
Geo Id ParentID
India ...