aaharris (3/27/2008)

---

Thanks for the advice, Ian.

I did actually think about doing it that way when I planned out the db structure, but decided against it mainly for two reasons:

1) ...

Mike - what does SELECT @@VERSION tell you? That will tell you what database engine you're running. I'm sorry to say - I suspect it's going to...

Also - I could swear that SET ROWCOUNT was "on its way out", i.e. being deprecated. I will have to see if I can dig that up.

The TOP syntax works for me if you put the TOP between the UPDATE and the name of the affected table.

As in -

UPDATE Top(@rowsperbatch)

...

Agreed - like CRC mentioned, CASE conditionally adjusts the row output, but it doesn't filter rows (prevent them from being displayed). Add a WHERE clause, and use that to...

Grant Fritchey (3/28/2008)

---

Honestly, neither.

What scares me is medical data. I was working for a software start-up that provided software to doctors. Not only did it store full patient history, but...

If I understand it right (I did end up needing the data to figure this out) - you're looking to pull out the latest rowcounts by table, and compare them...

There are quite a few articles in the Articles section dealing with just that... Among which:

Anatomy of an incremental Load[/url]

This might be heretical to some, but here goes anyway... Is there a critical reason to do every office every day? I mean - I see what you're...

There's a SQL Server Tuning and Performance guide for Intel LanDesk here:

http://community.landesk.com/support/docs/DOC-2356

you might care to spend some time in there. According to it - you have an "IO bottleneck".

How...

Christopher Ford (3/27/2008)

---

According to the link:

SUM(OrderQty) OVER(PARTITION BY SalesOrderID)

That works fine...

Why can't I remember what it was about that, that would be really nice to have...Several people have...

Notice I just said "it runs", and...

This runs:

drop table #mytemptest

go

create table #mytemptest (id int identity(1,1) primary key clustered,

...

Adam Haines (3/27/2008)

---

Matt, can you use over with the sum of a calculation? I have never tried, but I believe the over is used for deterministic columns. Like...

cjudge (3/27/2008)

---

Matt,

Yes, the @@fetch_status test was mistyped in the second example - proves that code should never be cut-and-pasted.

I appreciate your thoughtful answer: rather than telling me not to...