I don't know whether you have a calendar table or not - I'm guessing there's none...

So, please have a look at the Tally Table article I linked in my signature...

Since it's not really appending a new node but mor something like:

1) delete last row of xml file (<Employees>)

2) insert new lines (<Employee>

<Name>Adam</Name>

<Address>Washington</Address>

<Phone>234-567-8901</Phone>

<Employee>)

3) insert last row (<Employees>)

I'd rather export the...

I'd assume that the columns you're updating in table 2 are part of one or more index.

If so, your update requires an index update as well.

Would it be possible to...

Where do you have your xml data?

Is it a file or a xml column in another table?

If it's a file, do you need to append it (assuming appropriate node structure)...

Something along those lines should work:

SELECT COUNT(*) 'Total',

sum(case WHEN TYPE = 1 THEN 1 ELSE 0 END) AS 'TYPE 1',

sum(case WHEN TYPE = 1 THEN 1.0 ELSE 0 END) /Count(*)...

Did you try asking this question in a MySql forum?

It's more than likely that you won't be able to use the SQL Server solutions you might get here.

On the other...

Would you mind sharing what you've tried so...

looks like you're using float data type for at least one of your columns.

This will give you approximate results (see quote below).

You might want to change it to numeric(p,s) data...

What have you tried so far?

I'd recommend reading the articles regarding CrossTab and DynamicCrossTab (if required) as referenced in my signature.

Before doing so you probably should get the data in...

jb-1079038 (11/25/2009)

---

etc. etc. where the (10) & (11) are the month and the numbers after the space are time taken to logon that day, and the commas used as delimiters...

Can't really help.

here's the complete script I'm testing with (please note that I change the name of your original table):

CREATE TABLE [dbo].[tblInsiderXMLData_test](

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

[CIK] [int] NULL,

[xmlFileName] [varchar](300) NULL,

[xml_data]...

What is the table structure of tblInsiderXMLData ?

And how many rows are in that table?

Since I cannot confirm your statement (your data will return only two rows when I run...

I'm sorry... I used an XML variable to test the XQuery against.

Using the table name and yolumn you mentioned before it...

Unfortunately, your expected output does not match your sample data (e.g. there is no issuerCik with a value of 1000047).

Also, the table structure of your expected output is not clear...

The most helpful link I found on the web was: http://devio.wordpress.com/2008/03/04/retrieving-xml-data-in-sql-server-2005/ (searching for "sql 2005 Msg 9402").

Interesting part when playing around with the data on my machine: I could easily...