You are right D'Archy .The section table should not be populated with the records for Module 4.

Apologies for that ..Just execute the following script and it should give you the...

Hi All,

The following are the references that were used in the write up for the article.

It has been missed during the compliation of the article.Please refer to the reference for...

Jeff,I think there is too much made about the plagarism stuff.Everyone understands it.The theoritical part of the defintion of CTE for instance is used referrring to MSDN and I have...

Thanks for the comments.I think this would definitely help me to better my articles in future.

In the next article I have concentrated more on providing the examples rather than describing...

If you read the article properly

The article clearly states the below

For further reference on CTE read the link: http://msdn2.microsoft.com/en-gb/library/ms190766.aspx.

If you are expecting us to know the features of...

Thanks all for the comments on the article.I do agree there has been a bit of typing errors ,but I would be more careful next time.

The whole idea of writing...

Yes you can have both ..

oops looks as if the question is deleted

Use the xp_xml_preparedocument.

read more about it in books online

Could you elaborate a bit further as to whats ur exact requirement

Hi Avanthi,

Could you please provide some sample data

Altering the Column to have Identity column works fine when its done using Enterprise Manager.

whats the error that you get when you execute the query using Dot net

I would suggest that you create the temp table with the required data.

and then re-create indexes on them.

If I have understood your question correctly,then summing the data would give u the desired results