Jeff Moden (1/17/2009)

---

Grant Fritchey (1/17/2009)

---

Ninja's_RGR'us (1/17/2009)

---

So what?, only 2 people on that thread answered without reading (or understanding) the question.

Since when reading the full question a requirement of posting an...

If you were a marketing person for CDW - knowing what the top five selling products are within each sales department would be something important. The last x times...

I know this might not be the gearhead way to do this, but the Schema history report does the accessing of the default trace for you. Just simply right-click...

Agreed -...

RBarryYoung (1/15/2009)

---

Ramesh (1/15/2009)

---

Since you are using SQL 2005, you have the windowed functions and the OVER clause....

Here is that query

SELECT *

FROM (

...

Wow - she's fast!!!! Beat me to it!

not SUPPOSED to be interchangeable.

Not to niggle excessively,...

Just be careful of the possible perf pitfall with the windowed Aggregate function. Keep in mind that that will get evaled for EACH ROW in the rowset (which is...

Steve Jones - Editor (1/15/2009)

---

Well it is steel, and likely move's fast in Gail's hands, but no, it's not a bike.

http://en.wikipedia.org/wiki/Katana

Got to play with sticks last night, Filipino style last...

Lowell (1/14/2009)

---

Matt that's interesting, i didn't know about WITH SCHEMABINDING to a function...

does the results have to come from a SELECT statement in order to be deterministic?

I'd assume that an...

rules of thumb:

- unless you mark a user defined function as SCHEMABINDING (to signify that it is deterministic), the function will essentially be run once per line.

- the...

It has to make a decision once and for all what data type each column is going to be. In order to do that - it has to look...

If you assigned a "default" customer ID other than NULL, you could then enforce a unique constraint (to prevent duplicate customer+cat entries)

As for me - I'd look at:

;With CatInnerCTE as

(select...

how about

update mytable

set myfield = replace(myfield, '"','')

You need to make all of the values being returned the same type. In your case - two of them at CHAR, one is INT. Because of that...