Without seeing the code, we can't really give an answer.

I'd want D and Z to also use RAID-10 as well.

Okay, what would you like us to do? We, unfortunately, can't see what you see.

Pretty sure you were getting syntax errors.

Try the following:

DECLARE @BatchSize INT

SET @BatchSize = 1000;

WHILE @BatchSize <> 0

BEGIN

with Remove as (

select

...

Will also need the DDL for the views/tables involved including indexes defined on the tables, the code you are running.

My tabs are set to 4 as well, but I also have SSMS replace tabs with spaces.

Let's start with the job description you are using when advertising the position.

Next, how about more about the company and benefits.

I'll will be honest, I'm not looking for a new...

Can you post the code for the error handling procedure? Also, what is (are) the exact error message(s) that are being returned from this procedure?

Stefan Krzywicki (7/25/2012)

---

Brandie Tarvin (7/25/2012)

---

Stefan Krzywicki (7/25/2012)

---

Brandie Tarvin (7/25/2012)

---

Taking a tangent...

I've blogged about this subject before, but didn't get much of a response other than a few laughs from people...

vikingDBA (7/25/2012)

---

I would bet that if you are doing the aggregate part, it is essentially the same. Change the SUM(something) or whatever it is to ISNULL(SUM(something),0) or something similar...

I agree as well, get with the team that supports the COBOL app and ask them to help you understand the tables used and how they relate to each other.

I...

Jeff Moden (7/25/2012)

---

Stefan Krzywicki (7/25/2012)

---

I didn't because I didn't want to pile on and distract from the OP's question. Enough that a few people are doing it. Unless the consensus...

Something you should do when posting code. Before posing it, create an empty database, run your code there. If it doesn't work, rework it until it does run...

forsqlserver (7/25/2012)

---

I want to do this actually this

===================================================

with Remove

as (select X.id1 from X

except

select X.id1 from X inner join Y on X.id2 = Y.id2)

DECLARE @BatchSize INT

SET @BatchSize = 1000

WHILE @BatchSize...

sivag (7/24/2012)

---

sorry

Lynn Pettis

i understand what u said now and i am sorry i didn't response for that before thread plz tell me...