In Progress

TSQL Stored proc/View required for adjacency tree

Overview:

We run an in house created CMS with a flexible tree structure to create URL’s and lists of pages.

It uses the adjacency list model to represent the tree in SQL 2008. It was started this way back on SQL 2005, and uses a simple parent / id relationship.

We currently generate a number of pieces of data to work with the tree after we have gathered the data from SQL. The issue with this is that when the tree gets large, we transfer more data than we need to the application because we need it all to be able to create the required information.

We have the ability to extend this data model in any manner we please using a series of tables to define data types and data saved against the content. We currently pivot these rows of data into columns in the application.

Because the data set can grow to be large and we are going all this work on the application side, this is now creating an issue, and we see the opportunity to have this data generated in SQL and saved in a View so that it is kept up to date by SQL Server.

Deliverable:

Design and implementation of a set of SQL 2008 Stored Procedure / Function that can be executed to select the data required with 3 extra fields on the query result for Depth, URL, and ParentList. It should also select the custom data to produce new columns populated with data based on the extension tables. Ideally this could be implemented into producing the data to a view so the data is cached on the SQL side.

Please PM me for a Non Disclosure agreement. Upon signing I will provide a Full brief and DB diagram.

Skills: SQL

See more: adjacency tree sql, tsql creating tree view, adjacency tree tsql, adjacency tree sql 2008, sql 2008 adjacency, work view, view work, view more, uses of tree data structure, uses of data structure, types of tree in data structure, types of data structure, types data structure, tree types data structure, tree structure in c, tree query, tree of data structure, tree in data structure using c, tree in data structure, tree house design, tree data structure types, tree data structure in c, tree data structure implementation in c, tree data structure c, relationship tree

About the Employer:
( 3 reviews ) Surry Hills, Australia

Project ID: #1134514

Awarded to:

tejas34

As discussed..

$225 AUD in 7 days
(17 Reviews)
5.1

26 freelancers are bidding on average $360 for this job

HussienSharaf

HI, I m excellent SQL and database expert . Plz check my profile. Regards, Hussien Sharaf

$520 AUD in 4 days
(13 Reviews)
6.4
guevanjr

Please consider my bid. Thanks,

$250 AUD in 5 days
(3 Reviews)
2.5
YankoNik

I'm Microsoft certificated professional since 2003 year. Please check Pmb.

$250 AUD in 6 days
(5 Reviews)
2.2
patelrajan2000

please check pmb

$300 AUD in 5 days
(6 Reviews)
2.2
phobosq

Hi, experienced MS SQL Server DBA/developer, I'd be happy to help you.

$300 AUD in 5 days
(1 Review)
2.0
Cydertech

HI please check your PMB.

$350 AUD in 5 days
(1 Review)
1.8
yehia111111

Hi,kindly check your PMB

$350 AUD in 8 days
(1 Review)
1.5
jadav0000

Hi, Please have a look on profile.. I am ready for your work.. Thanks, Suva

$400 AUD in 7 days
(0 Reviews)
0.0
ssomaiya

I have 10+ years of experience as a microsoft professional and Database expert. I am very professional and have excellent communication skills.

$450 AUD in 4 days
(0 Reviews)
0.0
mithilesh0205

Please see PMB for details.

$300 AUD in 7 days
(0 Reviews)
0.0
patelpc

I am SQL Expert and worked on many projects (that includes N no of down/up level calculation using SQL stored procedures) with extremely complex calculation before! So, it would be very easy for me to solve all your pr More

$250 AUD in 5 days
(0 Reviews)
0.0
LakshmanT

Hi, I am Microsoft certified SQL SERVER Database administrator. You can see my profile. I can finish your task in time as you expected for that i will be in contact with you regularly. Thanks, lakshman.

$650 AUD in 20 days
(0 Reviews)
0.0
Ausodev

There is very interesting project for us. We are specializing in this kind of work. Our team of DBA experts has done many similar projects and we can do this one above your expectations extremely quickly with high qual More

$400 AUD in 5 days
(0 Reviews)
0.0
rajibalahsan

Please check PMB.

$250 AUD in 12 days
(0 Reviews)
0.0
AccuPro

Can do this.

$750 AUD in 10 days
(0 Reviews)
2.4
RedDevilic

Hi. I'm expert in SQL Server. I can solve your problem.

$400 AUD in 5 days
(0 Reviews)
0.0
jcgo810326

I can do this, need more details your project...

$750 AUD in 7 days
(0 Reviews)
0.0
sarathi87K

when will try start

$300 AUD in 20 days
(0 Reviews)
0.0
orbelmkrtchyan

Hi! I am new on [url removed, login to view], that's why I bid with this amount and that's why I will do project on time.

$250 AUD in 4 days
(0 Reviews)
0.0
elsoft

Hello Employer I am an expert Database developer with great skills in both Oracle and SQL Server.I am new to freelancer without a rating but I have accounts at Elance(josephj1989),Odesk(josephj1989) and stackoverflow( More

$250 AUD in 10 days
(0 Reviews)
0.0