Hi,

you could use something along those lines:

SELECT DISTINCT

c.value('@Id[1]','varchar(30)') AS FeatureID,

c.value('ReadPermission[1]','varchar(30)') AS ReadPerm,

c.value('WritePermission[1]','varchar(30)') AS WritePerm

FROM @FeatureList.nodes('Features/Feature') AS T(c)

/* result set:

FeatureIDReadPermWritePerm

6a698c85-4e95-4827-87b4-6eb4d7"true""false"

*/

In that case I'd assume you're doing some kind of grouping with the data.

I'd recommend to do the aggregation on SQL Server side and select the aggregated data into SSRS....

Hi Trudye,

it would help a lot if you could set up some sample data (DDL for table, insert statement for samples), the expected result based on the sample data and...

I consider cursors as a last resort: If I can't find any other way to get the task completed with a "column based" solution I still have the RBAR (=...

You're very welcome!

If it is a standard from w3org should it not recognize that...

Hi Vishal,

you might want to provide DDL for the table together with some sample data and your expected result. This will help us to help you.

Please see the link in...

triple post.

please continue here .

triple post.

please continue here .

Well, there wasn't that much I did other than posting a link. 😉 You did the major stuff all by...

Hi aparna,

the problem is within your xml data:

availVotesPerIssuedCapital xsi:nil="true" xmlns:xsi="abcde.com"

votesAgainstPercAvailVotes xsi:nil="true" xmlns:xsi="abcde.com"

votesOpenPercAvailVotes xsi:nil="true" xmlns:xsi="abcde.com"

votesForPercAvailVotes xsi:nil="true" xmlns:xsi="abcde.com"

Those elements are part of a typed element structure, which normally is used with a...

Hi Lynn,

I wish Kassondra all the best and I hope she'll be always stationed in safe areas!

Are you sure you'll use DTS packages?

Reason for asking:

You posted in the SQL2005 forum. In that case you need to use SSIS.

If you're on SQL2000 you should ask the site...

three links I'd recommend to look into:

http://sqlblogcasts.com/blogs/simons/archive/2006/11/14/Referencing-Parent-nodes-in-XQuery-is-expensive.aspx,

http://www.sqlservercentral.com/Forums/FindPost417131.aspx, and

http://articles.techrepublic.com.com/5100-10878_11-6140404.html

I, personally, moved from OpenXML to XQuery for the following reason:

I can store xml data as xml type in the database (if I...

From my experience the fastes way would be using BCP with indexes of the target table disabled (unless the source file is already in the right order or there are...

You don't "have to".

There are -almost- always alternatives.

Maybe this blog describes an alternative for you.