In Progress

Transact SQL Hierarchical Queries

Require resource to build Hierarchical Transact-SQL Queries

Table 1 Geoboundary: Name (city, state, sales territory)

Table 2 GeoboundaryType: Name (categorises geoboundary state, city etc)

Table 3 GeoboundaryAssociation: FromGeoboundary - ToGeoboundary

Table 4 GeoboundaryAssociationType (describes association- city to state)

Table3 contains geographic boundary pairs (to and from) i.e.

postcode to suburb

suburb to city

city to state

Need to return all elements of any hierarchy as a result to be used in a form:

for example user enter a postcode:

-postcode is passed as the query input

-result postcode, suburb(s), city, state

-suburb is passed as the query input

-result postcode, suburb(s), city, state

Although the examples are around zipcodes, suburbs, cities, etc table1 stores any geographic boundary as (Sales Territory, Government Region)

A GeographicBoundary may or may not have a relationship defined in table 3

Would also like to determine whether to restructure to use hierachyid in tansact-sql we are using SQL Azure

Skills: Azure, Database Programming, Microsoft SQL Server, SQL

See more: sql query to get hierarchical tree, sql server recursive cte ordering hierarchical result, sql hierarchy table design, sql recursive query to find parent, sql hierarchy query child parent, sql server parent child hierarchy, sql query to get recursive count of employees under each manager, sql server hierarchical query example, Transact sql, transact sql threading, transact sql running totals, vb6 transact sql restore backup, transact sql convert est, transact sql load excel, transact sql 2005 dts, transact sql import excel, transact sql save file vbnet, save image sql server table transact sql, freelancing sql server queries, replace transact sql

About the Employer:
( 0 reviews ) Enoggera, Australia

Project ID: #17849639

Awarded to:


I'm web developer and working for SQL from 8+ years. I know database very well and managing very big databases from years. I can start this job immediately and can work according to your time zone.

$25 AUD / hour
(43 Reviews)

14 freelancers are bidding on average $37/hour for this job


Dear Employer, Greetings From Team Augurs..!! Coming to your project scope you can hire our exp programmer for developing your Transact Hierarchical Model with table 1 as Geo Boundary Name, Table 2 Geo boundary n More

$26 AUD / hour
(15 Reviews)
$47 AUD / hour
(45 Reviews)

Hi, I have 11 years experience in SQL server, c# and ssrs. Thanks

$29 AUD / hour
(44 Reviews)
$26 AUD / hour
(80 Reviews)

Hello , Dear How are you? I am very interested in your project and I am ready for discussing with you about project for now. I have experienced in developing Azure, Database Programming, Microsoft SQL Server, SQL. More

$41 AUD / hour
(10 Reviews)

Hello! I am Bob and I'm ready to join your team. I am well experienced with T-SQL so I think I can turn around this project quickly. I'm a software architect with 18+ years of programming experience. For the last More

$49 AUD / hour
(1 Review)

Dear hiring manager, Greetings! We are experts in Database programming/ Database development/ Database administration having strong skills in:- Experts with AzureSQL, T-SQL etc.. Oracle DBA 9i/10g/11g/12c  P More

$50 AUD / hour
(8 Reviews)
$55 AUD / hour
(13 Reviews)

Hi, A SQL Server, SQL Server Integration Services(SSIS), SQL Server Reporting Services (SSRS) and SQL Server Analysis Services(SSAS) expert here. Please feel free to discuss the project with me so that I can wrap i More

$25 AUD / hour
(2 Reviews)

Hi, In order to do this we either have to use procedure or if needed to be done in a query might be needing bit of test from optimization side. Having 9 years of database and unix experience, worked with sybase, More

$33 AUD / hour
(5 Reviews)

Full stacked, already have been completed through freelance, 2/3 tasks and 10+ years experience in TSQL..

$26 AUD / hour
(2 Reviews)
$41 AUD / hour
(0 Reviews)

Experienced (13 years) and Passionate Professional Senior SQL Server Database Administrator | T-SQL Developer | Business Intelligence Developer with extensive experience in all versions of SQL Server 2000 - 2017. More

$41 AUD / hour
(0 Reviews)