Oh I understand - I just have been battling this little point for years. It really should be a bit of a shared effort, each side for their own...

Be careful to read about the inserted and deleted tables in the appropriate versions of BOL. those tables are more available in new places in 2005 they were not...

Charles Kincaid (1/2/2008)

---

Good point Sarah. Can you imagine an employer who says not only am I going to give you a good income for your 40 per week but...

Jeff Moden (1/2/2008)

---

SELECT TOP (1400000 )

N = ROW_NUMBER() OVER(ORDER BY sc1.Object_ID)

FROM sys.all_columns sc1,

sys.all_columns sc2

Again, the...

oops -...

Steve Jones - Editor (12/31/2007)

---

The resume is just a first line filter. It is there to generate interest among dozens of other resumes.

Use keywords that will get caught in search...

I've become a big fan of the Brian Herbert/Kevin Anderson add-on books to the Dune Series. The House series and the Machine Wars were both very well done, and...

That was...

GilaMonster (1/1/2008)

---

I haven't seen a course...

Jeff Moden (12/21/2007)

---

The only way you could do that is to have the vendor make the NextID code so that you can "reserve" groups of ID's... I think they have...

I take a few days off, and I forget one of the better tricks I learned this year.... But I see Jeff dusted it off! (Good to see you're...

Well - the problem becomes MUCH simpler if you can implement CLR.

The Book online example for User-defined aggregates is a concatenate function, which would make this whole deal...

Still- looks to me that an old-style pivot syntax (the sum(case when ...end) type of statement) ought to do what you wish

Not quite sure I understood. You have an activity called billable time, and then you have 2 columns called billable/non-billable?

What happens if the Billable time has something in the non-billable...

But still - I'm kinda seeing what donaldW was getting at (i.e. a substantial increase in performance, much higher than the 40% you mentioned). I ran three tests earlier,...