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
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 40 napon belül
5,0 (47 értékelés)
6,0
6,0
12 szabadúszó adott átlagosan $35 AUD/óra összegű árajánlatot erre a munkára
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 name .
I have gone through the details mentioned in project scope and let me know when you are available for project discussion so that i can share my queries and development process with you.
we have team of exp programmer and user interface designer in our company with 4-7 years exp and we will deliver you quality and professional work from our team.
I will wait for your reply so that i can assist you in much better way.
Looking forward to hear on same.
Warm Regards
Sam
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.
You can check about this on my profile.
I will work very hard and best for you.
Best Regards
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 it up in a timely manner as per your requirements.
Thanks,
Murtaza
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, mysql, oracle.
Should be able to get the work done.
Looking forward for chat for further discussion.
Regards,
Vikram
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.
Delivered many critical database and ETL projects with proficiency for big giants like Royal Bank of Scotland (RBS) and United-Health Care Group (UHG).
Key Expertise -
Database designing, data modeling and administration.
Database programming and query optimization.
Designing ETL solutions using SSIS and Informatica.
Expert in MSBI (SSIS, SSRS, SSAS).
Data Visualization using Tableau and Power BI.
Data mining using OLAP cubes (MDM and Tabular).
Big data ecosystem using Sqoop, Hive.
Cloud databases like Azure, RDS and Redshift.
I have domain knowledge of US healthcare, investment banking etc.