Đã Đóng

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 change 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 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 DB diagram and a Full brief.

Kỹ năng: SQL

Xem thêm: sql tree adjacency list, 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, lists data structure, implementation of data structure, depth of tree in data structure, depth of a tree in data structure

Về Bên Thuê:
( 3 nhận xét ) Surry Hills, Australia

Mã Dự Án: #1053209

16 freelancer đang chào giá trung bình $407 cho công việc này

eperfections

We have strong grip on databases specially SQL Server. We have written stored procedures for large billing applications. Please provide database diagram with more explanation. We are suitable candidates for this projec Thêm

$250 AUD trong 1 ngày
(67 Đánh Giá)
5.9
subratparida

Please see my PM.

$400 AUD trong 5 ngày
(2 Đánh Giá)
3.8
DeoTech

Hi! Kindly see PM! Regards.

$400 AUD trong 7 ngày
(4 Đánh Giá)
3.5
mystic19

Check PM, please

$250 AUD trong 7 ngày
(4 Đánh Giá)
3.3
guevanjr

Ready to start.

$250 AUD trong 0 ngày
(3 Đánh Giá)
2.5
SSystems

Hi, Please check PM. Thanks

$250 AUD trong 1 ngày
(0 Đánh Giá)
0.0
eirikureiriksson

Hi, bid details are in the PM.

$700 AUD trong 5 ngày
(0 Đánh Giá)
0.0
bmircea

Please check PM

$550 AUD trong 5 ngày
(0 Đánh Giá)
0.0
eitguru

I have 12+ year experience with development and optimization of Database object like Stored Procedure, SQL Statements, Views, etc. I have majorly worked on User based menu that generated from SQL Server and consumed Thêm

$500 AUD trong 5 ngày
(0 Đánh Giá)
0.0
kishore2903

Having very good experience in writing the queries, if you provide the complete information, will do it. Regards.

$700 AUD trong 10 ngày
(0 Đánh Giá)
0.0
abdullah88

Dear sir After reading your project details,we are interested in this project and would like to bid on this project. we take care of our every client personally and has always long term [url removed, login to view] we are new Thêm

$400 AUD trong 40 ngày
(0 Đánh Giá)
0.0
RohitashBansal

Hi i have more than 7 years of experience. I can do this within define timelines. I am new on freelancer.

$360 AUD trong 5 ngày
(0 Đánh Giá)
0.0
GoodDBA

I have 12 + yrs It experience, I am very strong database design and development. I do like you to work with you on long term basis.

$250 AUD trong 1 ngày
(0 Đánh Giá)
0.0
raguvenkat

Being New I am interested in proving myself.I have about 9 + years of experience in DB development

$250 AUD trong 7 ngày
(0 Đánh Giá)
0.0
SlickSystems

Hi, I have sent you a PM regarding my bid for this short piece of work.

$500 AUD trong 4 ngày
(0 Đánh Giá)
0.0
askids

Please see PM for details.

$500 AUD trong 6 ngày
(0 Đánh Giá)
0.0