WolforthJ (3/28/2012)

---

There are just too many things wrong with this article to address. I can't argue that the perception that programming is dead is true, and I can look around...

One can learn to program and be a hell of good programmer without ever stuying computer science or anythig related to it....BUT be sure that this person will study by...

These days I found self called developers or programmers that don't know the meaning of OOP and C or C++ are "ancient" languages, nevermore used :w00t: Study computer science, it...

I use too a mix of paper/keyboard when possible. If I need to pay attention to what is said then use paper and pencil, if we are more on a...

Sorry, this question should be answered on a .Net oriented forum, is a no sense trying to achieve this on SQL.

As replied on other post, finally the transformation is taken place on client side using .net framework. I should investigate further on the annotated schema possibilities

Everything working, but for now the transformation is done on client side using .Net framework. I use a sql procedure to generate the needed XML. Then using an XSL saved...

Seems that the annotated XSD schemas could be a solution but now I do not have the time to go deeper on the subject. I already have a working solution...

azdzn (1/12/2012)

---

I'm not sure this is possible.

Why don't you just apply an xsl transformation ?

Here is an article to do it inside SQL Server :

http://www.sqlservercentral.com/articles/MDS/75932/%5B/quote%5D

Hi azdzn,

I've already posted...

Found this other one with similar approach but no need to have installed the Master Data Services. I'm running the sql express version where is not possible to install the...

Corrected the script and added new columns to the tables related to the XML/XSL templates:

CREATE TABLE [DefaultMessage](

[DefaultMessagePk] [int] IDENTITY(1,1) NOT NULL,

[Text] [nvarchar](max) NULL,

[PriorityOrder] [int] NOT NULL,

[DefaultMessageCategoryFk] [int] NOT NULL,

[XMLTemplate] [nvarchar](max)...

One less to go...very informative as previous ones

But as on previous posts of this XML series, the links to the code are empty

yazalpizar_ (12/23/2011)

---

One question, the series of posts "XML Workbench..." jumps from II to IV and then to X. I'm missing some post in the middle? I can't find the III,...

Need to do some "homework" with the namespaces feature.

Here is the code with comments in spanish:

--=================================================================================================================================

-- XML Workshop Part V Namespaces: el uso de NAMESPACES permite desambiguar el nombre de...

Almost finishing these series of XML workshop, really helped a lot.

The proposal of adding FOR XML EXPLICIT, ROOT('CustomersByRegion') works for me too, I'm using SQL 2008R2

Again in this post the...