Hi,

that's exactly what the csv format is supposed to to:

save the data as Comma Separated Values.

What data do you expect?

Regarding your statement "I don't have the database anymore,..": How about...

Please provide sample data with the result set you're expecting.

The statement "how to return the two columns together" is not clear.

When running your test code the result shows:

13

...

As per BOL as well as Jacob Sebastians great Book "The Art of XSD" there is no way to remove an element from a stored schema using T-SQL. The only...

Hi Gail,

I've been through this on a different thread as well. The html code itself is fine, it's just the way it's been displayed.

If you need the original xml code...

Did you get a chance to figure out "who you are"? (see my post above)

PS: I have the strong feeling that most of the folks around here would find it...

You probably need to change...

Some thoughts:

First, you shouldn't use master database for your application data. Create a separate database.

Second, if you don't have any access to the master database you might have an issue...

Hi,

I assume your getting the following error message:

Msg 2337, Level 16, State 1, Line xx

XQuery [modify()]: The target of 'replace' must be at most one node, found 'attribute(*,xdt:untypedAtomic) *'

The reason...

WHAT is your question?

Are you sure you're running SS2K5? (TYPE=INNODB and some other synthax throws a syntax errors - you won't even get to any permission check with the syntax...

Did you notice that GSquared didn't reference the Type alias to an XML schema like you did?

What happens if you run the SELECT the same way?

If you still get less...

Hi,

Suggestions/thoughts:

1)

One of the biggest problems seems to be that VolunteerHours.EIN_NR is a varchar column. Does it really contain any characters?

Reason for asking: Since the view casts all underlying columns...

Hi,

please post sample data as described in http://www.sqlservercentral.com/articles/Best+Practices/61537/.

Your sample data should include table definition, the namespace declaration as well as some sample data that pass and some that fail.

My first...

Hi Flo,

looks like we're running a competition today...

You beat me on that one :crying:

Obviously you're not enjoying the Holiday the old-fashioned way... Neither do I 😛

Would the following check help (for details please see BOL)?

CASE

WHEN ISDATE(b.LAST_DAY_WORKED) = 1 THEN b.LAST_DAY_WORKED

ELSE ''

END

Hi,

I assume you're missing the namespace declaration.

;WITH XMLNAMESPACES (

DEFAULT ''

)

SELECT node.l.value('text()[1]','nvarchar(20)') as fieldname

FROM my_xml_Data cross apply xml_data_column.nodes('/MyPostAd/Ad/MyPostAd') node(l)

/*

result:

fieldname

---------

[node]

[node]

[node]

*/