Million of thanks . It worked for me. 😉

Please help me guys

Declare xml file as this

declare @ds as xml = N'

<odds>

<FIDS>

<English>???</English>

<Location_x002F_Explanation>Operational message area - Displayed with the Delayed Status...

I feel inner join is very simple and easy to understand and good performance.. well i knew this trick to solve but hardtimes we can't solve small issues. :)..

http://www.sqlservercentral.com/Forums/Topic1248766-391-1.aspx?Update=1

Thanks for the reply..

Similar post : http://www.sqlservercentral.com/Forums/Topic1248766-391-1.aspx?Update=1

Thanks a million.. which is very simple and easy. You are a champ!!

Million of thanks for every body who helped me in learning CTE and achieving task. I have created function for this and used in procedure.

[font="Tahoma"]Million of thanks for everybody...

Well, i am creating a search form for emp details where the emp details are filtered based on four conditions

1. unit

2. department

3. Section and

4. Employee no.

As i have already...

Thanks a lot bro. It helped me a lot but has a little issue back again..

How should i get employee details when i pass the unit id as well...

Well in this case , kindly find the table schema and data below:

create table #organizationdtls

( oid int

...

Rather than refering old posts, if possible reply with any proper solution.

kindly pass parameter oid = 10 eg.

SELECT Emp.*

, OH.orgname, OH.orgUnit, OH.orgDep

FROM cteOrgHierarchy OH

INNER JOIN #Employeedtls AS Emp

...

kindly pass parameters as oid = 10 but not 13 as oid nor even empid = 1234. It should give same results becz this employee is related to unit 10...

thank you bro.. but it doesn't return emp details when i hit querry like this

-- Statement that executes the CTE

SELECT Emp.*

,...