Antares686 (4/1/2008)

---

The only way I found was to setup replication and replicate the DB then use the sp_repldone. Then I removed replication and all was well. Probably could look at...

The only way I found was to setup replication and replicate the DB then use the sp_repldone. Then I removed replication and all was well. Probably could look at sp_repldone...

Right, using GROUP BY ... WITH ROLLUP you can sort with the GROUPING function like so

ORDER BY

(CASE WHEN GROUPING(Byteid) = 1 AND GROUPING(Variance) = 1 AND GROUPING(Distribution) = 1 THEN...

I currently am in a conference call but I almost bet you could accomplish your goal with GORUP BY WITH ROLLUP like this

SELECT

Byteid,

Variance,

Distribution,

SUM(Total) Sum_Total,

SUM(Tor) Sum_Tor

FROM

dbo.TTor...

Just thought about it, if I am going to play some game for SQL DBA's maybe I want a little more Eye-Candy. Maybe something like Dead-Or-Alive SQL.:P

Hmmmm, maybe I need to pull out my copy of Doom source and write SQL Wars myself. Like the UNIX thing, never heard about that.

I want the half-geek/half-nerd with the C#/SQL class.

And I was looking to frag the Oracle DBA's. 😀

Above all else, if you are going to go back to school, do it because you want to and not because you feel like you have to. I stopped 20...

Aurelio Alvarez (3/28/2008)

---

A SSN is a unique identifier as well as anything else is. If they are saying John A Doe with SSN 123 is the same as John...

How about this, then consider it when combined with biometrics

Link: Illicit software blamed for massive data breach

What exactly do you mean? What is your setup and what is the total RAM?

rbarryyoung (3/28/2008)

---

Matt Miller (3/28/2008)

---

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...

Did you set you batch size, when you call call like this

EXEC spUpdatepare 25000

this will affect 25000 records in the batch.

Was curious about that, didn't think top was correct in the syntax. Try this

CREATE Procedure spHugeTable_IncrementalUpdate( @RowsPerBatch int )

AS

SET ROWCOUNT @RowsPerBatch

UPDATE

GHOSTDATA

SET

...