You may use this also.

with abc(managerNumber, managerFirstName, managerSurname, id, employeeId,

employeeFirstName, EmployeeSurname, employeeJob)

As

(SELECT

tab.col.value('employeeNumber[1]','VARCHAR(20)')AS managerNumber,

tab.col.value('first[1]','VARCHAR(200)') AS managerFirstName,

tab.col.value('surname[1]','VARCHAR(200)') AS managerSurname,

tab1.col.value('./@id','VARCHAR(20)')AS id,

tab1.col.value('employeeNumber[1]','VARCHAR(20)')AS employeeId,

tab1.col.value('(employeeName/first)[1]','VARCHAR(20)')AS employeeFirstName,

tab1.col.value('(employeeName/surname)[1]','VARCHAR(20)')AS EmployeeSurname,

tab1.col.value('job[1]','VARCHAR(20)')AS employeeJob

FROM

@b-2.nodes('//workingGroup/managerName') tab(col),

@b-2.nodes('//workingGroup/employeeGroup/employee') tab1(col) )

select min(employeeId) as...

Hi,

You can use this query.

DECLARE @Xml XML

SELECT @Xml = ' Your Xml here'

-----------

SELECT

tab.col.value('employeeNumber[1]','VARCHAR(20)')AS managerNumber,

tab.col.value('first[1]','VARCHAR(200)') AS managerFirstName,

tab.col.value('surname[1]','VARCHAR(200)') AS managerSurname,

tab1.col.value('./@id','VARCHAR(20)')AS id,

tab1.col.value('employeeNumber[1]','VARCHAR(20)')AS employeeId,

tab1.col.value('(employeeName/first)[1]','VARCHAR(20)')AS employeeFirstName,

tab1.col.value('(employeeName/surname)[1]','VARCHAR(20)')AS EmployeeSurname,

tab1.col.value('job[1]','VARCHAR(20)')AS employeeJob

FROM

@Xml.nodes('//workingGroup/managerName') tab(col),

@Xml.nodes('//workingGroup/employeeGroup/employee') tab1(col)

-- Output

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

--managerNumber ...

Hi,

I think your xml file is not uploaded properly...

Please check once..and upload the correct one..

Cheers!

Sandy.

Hi All,

This issue got resolved. Actually one of the file missed from the Application Data folder from documents and settings folder.

It got resolved once log off and login again on...

Jack,

I think you are not clear on my question.Let me clear you...

As per my question, User1 is not trying to open MRS report in SSRS enviorment.

Actually he wants to...

Congrats..Gail..:)...You deserve it..:)

"All The Best....:)"

Cheers!

Sandy.

luv,

you can use this:

set @Approve = (select top 1 convert(int,SettingValue)

...

SQL SERVER 2008 RELEASE 🙂 : May be middle of August or September....

Not sure??

Cheers!

Sandy.

Thanks gail...:)

Cheers!

Sandy.

Although I was not knowing it..

but still I use to respect gail more than MVP...

His Answer is so specific to understand the technology like anything..

thanks to gail 🙂 for nice...

Thats True...I do agree on this...

but What's about the MSDN then...??

Cheers!

Sandy.

Gail,

As MVP's are the people those who selected by the Microsoft itself... So I can consider their suggestion's as one of the selective answer for this topic....

Cheers!

Sandy.

Grant,

I am not talking about gail is rite or wrong...

I am looking for a answer which make sense with respect to performance and design prospective..

more over to that, if you...

Yes, Gail...

Your last post make sense for me...

Thanks...:)

Anyways I would like to open this question for others who have already got the exposer to this type of indexing too...

Cheers!

Sandy.

Please Check this:

http://sqlblogcasts.com/blogs/tonyrogerson/archive/2007/03/30/blocking-from-foreign-key-constraint-look-ups-clustered-blocks-v-heap-doesn-t-block.aspx

http://sqlblog.com/blogs/greg_low/archive/2008/07/29/indexing-foreign-keys-should-sql-server-do-that-automatically.aspx

Cheers!

Sandy.