Hi Friend,

thanks for your support.

but i already got this output..

using the below simple single query..

select * from Xml_Export listing for xml auto ,elements ,ROOT('Listings')

but i need above result with...

Try This One...

SELECT D.FileId, D.filetype, COUNT(*)

FROM #Tab1 D

GROUP BY D.FILEID, D.FILETYPE

UNION ALL

SELECT max(FileId), 'txt', 0

FROM #Tab1

Order...

After executing the above query i am getting the count like number of txt files and number of pdf files

group by fileid.

What i want is for any fileid if the...

Thank You Friend ...

Thank you so much...

Tc..

Thanks & Regards,

Saravanan.D

but stili i having a doubt ..

how to show the fist Record of the EmpID

Thanks & Regards,

Saravanan.D

hi Friends..

i got the Result ...

Select EmpID,EmpName,Department,max(Age),MAX(salary) from

EmployeeDet

group by EmpID,EmpName,Department

Thanks for Your valuable Guidance

Regards,

Saravanan.D

you pls show the First Record of the EmpID

what Ever You Take its ur wish...

thats not a problem...

you take it first record of the EmpID....

Thank you sir...

Thank you so much....

Take Care...

Regards,

K.D.Saravanan

wow fantastic work Mr.Tavis Reddick...

thank for ur support...

I Need to Speak About this Result to My Team Lead..

Here After We Decide to if it is a Source XML File is...

Hi Dave Ballantyne,

You Asked Me...

Hi,

you seem to be missing some very important data here.

your xml shows that "Brenda Smith" is a child of "Alexander Tuckings", but why ?

What data specifies...

Hi Sunil ,

The Required Heirarchy is,

[ CEO ]

1 -> President QA

->-> VP QA

...

Any One Please Help me...

please take it as Challenges...

Regards,

Saravanan.D

Any One Please Help me...

please take it as Challenges...

Regards,

Saravanan.D

Any One Please Help me...

please take it as Challenges...

Regards,

Saravanan.D