I agree with both of you. I had a tough time explaining the same at the UG meeting.

I think you have a few different options.

1. run a loop on table 1 and create a comma delimited string containing all the values for that record in table 2...

Try this

UPDATE TableName SET ColumnName = REPLACE(ColumnName, ' ', '')

It looks like there is a problem with the XPath expression you are using. For example, to delete the specified element, you should use the complete path to reach the...

Yes you can.

I once wrote a function that returns the number of rows that one or more tables contain. You can find the code here: http://www.sqlserverandxml.com/2008/01/find-row-count-of-one-or-more-tables.html

Abhijeet,

I have presented the sample code for achieving this in the following post: http://www.sqlserverandxml.com/2008/08/how-to-generate-delimited-string-using.html

Hi Philip,

All of us are trying to help you, but are shooting in the dark. I see that you have a simple problem that is not solved even after we...

Waiting for philip to answer, I guess he has the right results 🙂

Thanks Matt and Dugi

Hi,

I altered your query slightly (BLINDLY).

Please see if this produces the required results

SELECT

case when rn = 1 then CustomerName else '' end AS CustomerName,

case when rn = 1...

The example given in my post follows the rules defined by the RSS specification: http://cyber.law.harvard.edu/rss/rss.html

The feeds generated are validated by http://www.feedvalidator.org.

If you want a customized version of the XML...

Please post the script of your tables.

Replace "InvoiceValue" in the outer query with "PaymentMade".

Here is how it works.

Your outer query (outside the brackets) can access only the columns selected by the inner query. The inner query...

May be this one?

SET DATEFORMAT DMY;

SET NOCOUNT ON

DECLARE @t TABLE (Product CHAR(3), Price MONEY, Date DATETIME)

INSERT INTO @t (Product, Price, Date) SELECT 'HDD',200,'01/10/2008'

INSERT INTO @t (Product, Price, Date) SELECT 'HDD',100,'19/09/2008'

INSERT...

Ok, I see a few more issues. I cannot run and test the code because I dont have your tables. So I am trying to suggest from what I see...