Then it is time to learn XSLT.

Do you have a reason to use ns0 for the prefix? Are you sending data to a tool that does not use a proper XML parser?

I have found it...

A couple thoughts. Where does the XML come from? If it comes from SQL, it would be easy to change the FOR XML to output the namespace.

I would...

That...

Thank you for this article. As a developer, I get slammed by management when the database I deployed runs slow in production. "Didn't you test it!!!!" I...

Can you provide a sample table that has data that should not return rows as well as where you do want rows. Something like this:

declare @t table (id int...

If rather than using the Table source or even a command with "Select * from " you actually spelled out the column name "SELECT IsOrderAGift from " then the package...

You can validate multiple elements in an XML file using .Net. But not using SQL XML.

I don't have the environment to test this, but I think that the code...

Do you have a parameter mapping of parameter name "0" to variable @filename?

SELECT [c].[Name],[c].[ItemID],[xl].[ReportID]

, MAX([TimeStart]) [LastRunDate]

FROM [dbo].[Catalog] [c]

RIGHT OUTER JOIN [dbo].[ExecutionLogStorage] [xl]

on [c].[ItemID] = [xl].[ReportID]

and [c].[Type] NOT IN (1,5) -- Not a folder or a...

A thought. I assume that you know of a row in the target that matches a row in the source. It matches on the key and on the...

Are the physician and surgeon keys I a table?

Try replacing CAST(... AS Date) with CONVERT(Date, ..., 112). Here is my hypothesis. Casting from a string to date is not deterministic because a change in the system...

What is the query (without for xml) that you need output in the format you like? Are the codes in your xml columns in the table you are querying?

jacksonandrew321 (10/11/2014)

---

Means I m getting error message. My query is given below:

update Employee set id='1' where username='markhenry'; I am trying to update my column id to 1 which is actually...