Hi,

it looks like the thread just ignored your xml sample data.

Please use [ code="xml" ] tags without spaces.

Just out of curiosity:

Let's assume you'd delete the first 75% ordered by primary key (hoping there is one).

How would you recognize that you've deleted too many rows? Let's say you've...

Hi Digs,

a couple questions/comments:

- Why are you using T-SQL to get the same results as you provided as input data?

- T-SQL can use the IN clause, but there...

Roust_m (6/30/2009)

---

This is exactly the article I read before setting the whole thing up. The only problem I have is not being able to retrieve the XML data in...

Hi Roust_m,

to begin with the easy stuff: your xml is not well formed. the following closing tags are missing either at the end of your xml or in between:

I just...

GSquared (6/30/2009)

---

If I'd been pressed to pronounce it as a single vocable, I'd have tended towards the English "easel" (as in a tripod used to display something, usually writing on...

Well, since it's an official abbr. do I now...

Now that's something I'd call a "Linguistic Freudian slip"!

ESL sounds very close to "Esel", which is German for donkey or jackass. :hehe:

Coincidence???...

Nice one, Jeff!!

Sometimes the occurrence of the word "PIVOT" isn't that bad, obviously... - especially when it comes together with an "UN".

Seems a little easier to deal with than the...

Hi Eswin,

just a few thoughts while you're working on providing the data:

- since you're using DATEPART(WEEKDAY ...) function you need to make sure that the setting for @@datefirst is a...

My first response was based on your statement:

espilman (6/29/2009)

---

... then the case statement will just help the first record. Subsequent records will have to follow the determined order for the...

Ok, I'm done with testing and I think I covered all possible occurrences (except NULL values since there is no business rule on how to handle such values...).

I used the...

espilman (6/29/2009)

---

Unless c1, c2, c3.. are intrinsically meaningless and are just data placeholders, then the case statement will just help the first record. Subsequent records will have to follow the...

How do you access Excel files? Are you using SSIS, linked server, openrowset or any other method?

From my point of view data format validation should be done before you even...

I'll do it, assuming you're covering travel and accommodation...