Transact SQL Hierarchical Queries

$25-50 AUD / hour

Σε Εξέλιξη

Αναρτήθηκε

πάνω από 5 χρόνια πριν

$25-50 AUD / hour

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

Ταυτότητα εργασίας: 17849639

Σχετικά με την εργασία

12 προτάσεις

Απομακρυσμένη Εργασία

Ενεργός/ή 6 χρόνια πριν

Ψάχνεις τρόπο για να κερδίσεις μερικά χρήματα;

Διεύθυνση Email

Πλεονεκτήματα πλειοδοσίας στο Freelancer

Καθόρισε τον προϋπολογισμό σου και το χρονοδιάγραμμα

Πληρώσου για τη δουλειά σου

Περίγραψε την πρόταση σου

Η εγγραφή και η πλειοδοσία σε εργασίες είναι δωρεάν

Βραβεύτηκε στον/στην:

@sflogics

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 ημέρες

5,0

(47 αξιολογήσεις)

6,0

12 freelancers δίνουν μια μέση προσφορά $35 AUD/ώρα για αυτή τη δουλειά

@feninsoftech

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

$29 AUD σε 40 ημέρες

4,9

(51 αξιολογήσεις)

6,7

@augurstech

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

$26 AUD σε 40 ημέρες

4,5

(19 αξιολογήσεις)

6,9

@mingxiao2008

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

$41 AUD σε 40 ημέρες

4,8

(14 αξιολογήσεις)

6,3

@murtaza1981

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

$25 AUD σε 40 ημέρες

5,0

(2 αξιολογήσεις)

3,9

@spryox

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

$33 AUD σε 5 ημέρες

5,0

(6 αξιολογήσεις)

2,4

@znawazch

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

$26 AUD σε 40 ημέρες

4,4

(3 αξιολογήσεις)

1,7

@AmitMehta81

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.

$41 AUD σε 40 ημέρες