Keep in mind that "failure" could very easily be just bad selection info being sent in the dynamicSQL. Meaning the process or query might not "fail" - it just...

Ninja's_RGR'us (11/21/2011)

---

bomborde (11/21/2011)

---

Revenant (11/21/2011)

---

ScottPletcher (11/21/2011)

---

Don't see how you can do this w/o an ORDER BY, but it's trivial with one:

SELECT TOP 1 Name, SUM(Consumption) AS Total_Consumption

FROM tablename

GROUP BY Name

ORDER BY...

p-nut (11/17/2011)

---

Sean Lange (11/17/2011)

---

Dev (11/17/2011)

---

It would be truly impossible to ensure 100% that you have the exact order every single record is inserted into a table. You could...

GSquared (11/17/2011)

---

If all uses of the data are fault tollerant because they do not ever rely on specific values, then the incorrect data from NoLock issues is probably okay. ...

AND not (gifteffdat BETWEEN '03/01/2008' AND '02/28/2009') --no gifts FY09

jared-709193 (11/2/2011)

---

Ok, so as I understand from this article... The slot array...

found it! using the wrong key words will get you lost each time.

What's a page?

jared-709193 (11/1/2011)

---

Lowell (11/1/2011)

---

I think Gail had posted that they are logically stored in the clustered index order, and not necessarily physically stored once you look inside a page.; there was...

jared-709193 (11/1/2011)

---

Matt Miller (#4) (11/1/2011)

---

Two things to consider:

- there's no such thing as a "physical order" in a DB. if you want to be able to track the...

EXISTS doesn't work that way. you could make it work, but I prefer using the EXCEPT syntax in this case (since you're using 2008). Something like:

declare @currentgrp char(1)

set...

Two things to consider:

- there's no such thing as a "physical order" in a DB. if you want to be able to track the ordering bacsed on when...

one word of caution on the XML approach: remember that it will tend to encode symbols, etc... which can get a bit hairy when dealing with things like >...

This is the kind of stuff I used to do in 2003 ofr these kinds of things (the DSN-less connections). This was written with 2007 in mind, so they...

Passed from where to where? using what technology?

I'm sorry but as currently stated - there's no good...

pschwartzbauer (10/27/2011)

---

If ROW_NUMBER is used instead of RANK, won't it produce unpredictable results in cases when there are ties? In R.P.'s data sample, rows 2 through 7 are interpreted by...