I have a table in SQL Server which I uploaded an entire xml file into. The table has 2 columns, Col001, Col002. Col001 holds all the xml text. Each row has one line of the xml file uploaded . Col002 holds the titles of sections contained in the xml, if no title is in the line of xml then a <NULL> is placed in Col002.
    I am looking for a way to extract all the xml lines in between titles to display in an ASP.NET webform. For instance, if a title is located in Col002 then it should gather all info up to, but not including, the next title and output that information to the browser through ASP.NET. Does anyone know of a good tutorial that relates to this subject. Any help will be appreciated. Thank you all.

It sounds like you need to look into the xpath querying capabilities of SQL 2005.

-Peter

I'm working with 2000. I've noticed that 2005 has much more of these capabilities. Is there any way I could do this in 2000?

    ok, I have another relatively simple question which should solve all my problems: The xml document that is being stored in the SQL Server DB works fine when opened as is from it's file location. However, when I attempt to open it from SQL Server it displays but not correctly formatted. To my understanding this is due to the xsl it is referencing.
    When I open it from it's original file location then it opens in IE which is compatible with the xsl stylesheet. When I attempt to open it from ASP.NET, which opens in Firefox then the formatting is not correct. As I understand it, you must include a reference to a .css from the xml file, correct? Is there any way I could solve this problem by having it always open in IE instead of Firefox? I set my internet properties back to their default and tried to set the dropdown box in ASP.NET to different browsers to attempt to find something that works but the same thing happens. Is there an easier way to fix this? Thanks

I figured it out. All I had to do was open File, go down to "browse with.." and select "internet Explorer" and set it to default. This may solve stylesheet problems if you are using .xsl, just in case anyone else has this problem. Thanks.