Wow! You didn't only set a very high standard with your first article (CROSS APPLY) - you continue to hold that level with each and every article since! Once again:...

The ORDER BY clause used with ROW_NUMBER specifies the order within in each PARTITION BY group. You might want to try

SELECT ROW_NUMBER() OVER (PARTITION BY P.prop_seql

ORDER BY ASV.booking_date...

Basically, the SB does the same like the job that did run every minute (data transfer across servers and email notification).

I haven't had the need to call an external application...

Lowell (4/26/2010)

---

in the past, you used to be able to use NET SEND to all the machines on a network; however, because of someone adapting that to throw spam around,...

gregory.anderson (4/26/2010)

---

It is still required because not ALL of the records are getting converted. There were some...

antonio jv (4/23/2010)

---

I have a book "Microsoft SQL Server 2005" but it does not cover all answers and more a read others opinions more confused it gets (SQL Server). I...

Hmmmm, .....

It seems like there is not much more room for speeding the current query up...

The question is: is it still required to store the successful import into PermitsInserted?

Basically, we...

@jeff: it's not that I'm actually advertising XML, I'm sure not. 😉

I just had to get used to it in order to get those "man in the middle" out of...

Jeff Moden (4/24/2010)

---

Heh... I'll take that correction... thanks, Lutz. I should have said that both XML and CSV's are a form of denormalization that should be avoided in favor...

Jeff Moden (4/23/2010)

---

I agree. IMHO, storing raw XML is as bad or worse than storing CSV's. Both are denormalized... both require special handling... neither can be optimized.

I believe...

Rob Schripsema (4/23/2010)

---

As Imu92 said, you don't give us a lot of details about how the data will look, but assuming it is all consistent with your sample and there...

You could use UNPIVOT followed by a PIVOT statement. See BOL (BooksOnLine, the SQL Server help system usually installed together with SQL Server) for details or post some ready to...

Assuming Amount_1 and Amount_2 will always be in a consistent order (ege. being able to sort it by and ID column which is unfortunately not present (or at least not...

Would it be possible for you to shred the xml files into relational table(s) (including proper indexing)? Maybe just with holding the values queried frequently?

A question on top: Do you...

Is this thread related to your other recent one by any chance? 😉