Hi Marin,

I'm not sure if it's overengineered but I tried the divide'n'conquer method, causing the numerous CTEs... 😉

DECLARE @date DATETIME

SET @date='2010-03-24 10:20:00'

;WITH

cte0 AS

-- find the latest order per customer...

So, what have you tried so far?

Hard to tell based on that limited information...

Please provide table def, sample data and your update query (or is it a cursor????).

For details on how to post sample data please...

What exactly is your question?

Please read and follow the first link in my signature on how to post sample data.

In your specific case: It is more than likely that you...

register 97758 (3/21/2010)

---

Thanks, but I was talking about how to make the XSD for use with XML Bulk Load, hence the title of the thread " XML Bulk Load -...

Roust_m (3/21/2010)

---

Both estimated and...

Would the following code snippet help you?

DECLARE @xml XML

SET @xml=

'<?xml version="1.0" encoding="UTF-8" ?>

<locations>

<location>

<id>11111</id>

<name>Business Name</name>

<address>

<street>111 Street Address</street>

<delivery_point/>

<city>City Name</city>

<state>ST</state>

<postal_code>44444</postal_code>

<cross_street/>

<latitude>33.00</latitude>

<longitude>-100.00</longitude>

</address>

</location>

</locations>'

SELECT @xml

SELECT

c.value('id[1]','int') AS id,

c.value('name[1]','varchar(30)') AS name,

v.value('street[1]','varchar(30)') AS street,

v.value('city[1]','varchar(30)') AS city

FROM @xml.nodes('locations/location') T(c)

CROSS APPLY

t.c.nodes('address')...

It seems like we have to start at the very beginning:

"Niederschlag" should be stored as a numeric value.

What you're trying to do is to change the german decimal notation to...

No....

Step 1: try to get your code for the insert and update right (that is performing it not row by row but set based). Once that's done, we'll help you...

What are you trying to do?

It seems like you won't need a cursor for it.

Side note: you can drop me a PM if you prefer to continue in German (my...

Hi Prakash,

either the column names you provided is wrong or you're using the wrong column (PId=31).

Other than that I guess you want to find the rows where your parameters are...

I think it's a great question.

Not because I've got it right (I didn't).

But it started a discussion on what we think about the QotD responsibilities in general. Instead of...

Here's what I came up with:

DECLARE @xml XML

DECLARE @strFieldName VARCHAR(200)

SET @strFieldName = 'txtFieldSubmitURLH'

SET @xml='

<panel>

<name>coolingContent</name>

<question...

What you could use is a query like the one below.

The disadvantage is that it will query all nodes on each and every level within the file.

What I'm trying to...