Stan Segers (7/16/2008)

---

Laurie Bantin (7/16/2008)

---

Have you read this article?

http://msdn.microsoft.com/en-us/library/ms345137.aspx

i think you can write the query in the new syntax much more clearly and easily (if you are using SQL Server...

To generate a CDATA section, you should use FOR XML EXPLICIT.

After building the INSERT QUERY, try to print it in debug mode and see if it looks correct..Then try to execute the query in management studio you could spot...

Hi,

It does not really help because I have no way to run it and see the problem. Meanwhile, my only guess is that something is going wrong with your REPLACE()...

could you post some script that reproduces the problem?

In our example, the REPLACE function is expected to remove the unwanted character (CHAR(0)). Try to run a SELECT query for the specific column and apply a REPLACE() operation and...

You will have to do a string operation to do this. Look at the example given in the previous session: http://www.sqlservercentral.com/articles/XML/62661/

I think I did not understand the questions fully. could you elaborate?

You need to create a page that executes the TSQL code and returns the resultant XML to the HTTP response stream. The caller (usually an rss reader or a browser...

You can find the total number of rows by using 'COUNT(*) OVER(PARTITION BY '')'. I think some one has already mentioned this earlier in this thread.

You can sort rows...

Thank you...

DEK,

Thanks for the feedback. Infact, this is something that I had in mind and will be coming up in the next sessions. One of the previous sessions has shown how...

I dont think a feed parser will complain for the namespace declaration on the item elements.

I had been writing another article on ATOM feed and realized that feed validators...

Thanks Phil,

And thanks for bringing up those great 'work-benches' at simple-talk. Learned a lot from you. 🙂

Thanks to every one! Special thanks to Steve and Jeff for being great educators. I learned a lot from Jeff especially on 'how-to-make-a-good-post' kind of stuff and realized many of...