your code...

Create View vwRecursiveAW AS

WITH DirectReports(ManagerID, EmployeeID, EmployeeLevel) AS

(

SELECT ManagerID, EmployeeID, 0 AS EmployeeLevel

FROM AdventureWorks.HumanResources.Employee

WHERE ManagerID IS...

Please give a example..............

(see Books OnLine). ..........I am unable to know the concept by reading.....can...

rbarryyoung, Not Clear to me, Give a Example....Please....

luv's

Milu.:)

hi Gail

==========

I got your point but I need one example of this{VIEW and CTE both i need to compare as per you, so i need both script.....}, I will be...

Thanks..

luv's

Milu.:)

Thanks,

luv's

Milu..:)

Thanks a Lot....

luv's

Milu..:)

Thanks..

luv's

Milu..:)

Thanks steve & sandy...

Nice explanation sandy..I am impressed..

as per you, I will go through this and prepare for the XML..

luv's

Milu..:)

Thanks to steve & all.:)

I just applied the what Sandy and Hari specified here....

Sandy thanks...so sweet of you..nice explanation....

luv's,

Milu..:)

made it encrypt.