Cancelled

Database Expert Requires

Hi,

Currently we requires database Expert ( long term) for our project/business database.

Responsibility :

1- Continuous upgrade the database.

2- Update the query/datas.

3- Optimize the procedures etc

All payment is made monthly basis.

But , it is essential that , the provider we select for this task must have proper knowledge of SQL SERVER 2000/ 2005(most preferable).

To make the selection , please go through following sample question,and submit the result/[url removed, login to view] me very clear, no provider is selected/entertained over PMB who NOT submitted this question [url removed, login to view] is [url removed, login to view] selected Provider receive more details as well as contract copy for further [url removed, login to view] take it seriously.

QUESTION :

------------------------------------------------------------------------------------------------------------------------------------------

There are two tables, NAMES (ID INT IDENTITY(1,1), NAME VARCHAR(255)) and RELATIONSHIPS(NAMEID INT , PARENT_NAMEID INT) linked via

NAME.ID=[url removed, login to view] and where top-most name has a PARENT_NAMEID=0.

Show a nested list of names including LEVEL, NAMEID and NAME, where LEVEL indicates the nest level(or depth) from the top, as indicated in the expected output(below).You may use functions, stored procedures views and other Transact SQL commands compliants with Microsoft SQL 2000 / 2005 (prefered).Use the Sample data (below) for

your convenience.

SAMPLE DATA

NAMES table content:

ID NAME

--------------

1 Frank

2 Jo

3 Mary

4 Peter

5 Amy

RELATIONSHIPS table content:

NAMEID PARENT_NAMEID

-----------------------------

1 0

2 1

3 1

4 1

5 2

Expected Output:

LEVEL ID NAME

---------------------

0 1 Frank

1 2 Jo

2 5 Amy

2 3 Mary

1 4 Peter

------------------------------------------------------------------------------------------------------------------------------------------

Thank you

Skills: .NET, ASP

See more: top query, sql database business, linked int, asp net commands, frank n, clear copy, stored procedures, sql views, sql commands, seriously, procedures, nest, int, frank, database upgrade, database microsoft sql, amy, requires, database question, contract database project, microsoft query top, contract copy, nested sql, sql nested query, sql optimize

About the Employer:
( 60 reviews ) Rhode macu, India

Project ID: #201350