I just did. Definitely not all of them but most of what I could...

Hi digs,

what's missing in your post is something like

CREATE TABLE #a(some cols)

INSERT INTO #a(selective cols)

SELECT [sample data] UNION ALL

SELECT [more sample data] UNION ALL

SELECT [even more sample data]

--target structure

CREATE TABLE...

Here's some "evidence of confusion" to support the need for fixing the issue (based on IE 6.0.2900.5512):

http://www.sqlservercentral.com/Forums/FindPost742192.aspx -> confusion caused

http://www.sqlservercentral.com/Forums/FindPost742141.aspx -> wrong color coding due to /* using XQuery

http://www.sqlservercentral.com/Forums/FindPost733805.aspx ->...

Well, that's something I "like" to see:

An OP who just throws in a request and stays focused on it. "Nice" one.

What I really like is the Freudian slip...

Please correct me if the following assumption is wrong:

It looks like...

Hi Steve,

to verify the QFX structure you could set up an XSD file containing the expected structure.

When you try to assign the QFX file to an XML variable bound to...

Hi,

another way to fix this problem would be to normalize your table structure.

Otherwise you could run into duplicates:

If someone would add two identical products in two different categories, how would...

Peso (7/5/2009)

---

In your CTE, ROW and VALUE elements are upper case, and in your cross apply the row and value path are lower case.

This results in an empty result. And...

What would be your expected result?

It looks like it would be required to fill more than just one table...

Edit: you might want to look up "XQuery" in BOL as well...

Hi,

you might want to look into the series of articles by Jacob Sebastian, for example this one[/url].

If you're interested in the rest of the articles please search for "XML...

I'm sorry for not asking all questions I have at once... :blush:

Your example has two rows with 12 rsp 15 seconds.

How would you handle those?

a) add it up in...

What rule for rounding values would you use?

The example you provided...

Hi,

your data seems not to lead to the expected result:

SELECT

DATEDIFF(ss,TranIn,TranOut) AS SECONDS,

COUNT(*) AS CNT

FROM #tmp

GROUP BY DATEDIFF(ss,TranIn,Tranout)

/* result

SECONDSCNT

01

11

41

51

91

121

151

*/

Reason for that is the first row just has a little...

If my math is correct you can (in theory) split a list of consecutive values from 1 to over 125.000.000 (assuming plain numbers e.g. 125000000 instead of 125.000.000, separated by...

First thought: Glad you found a solution.

But when I took a look at the link you posted a WHILE loop stared at me... :crying:

This is usually not considered to be...