First, question. Where is the backup file located, tape, network share (mapped drive or UNC), or a local disk?

My gut feeling, your backup is corrupt. If local tape,...

In addition to your execute plan, we will also need to see your query and the DDL for the table including all indexes that are defined on it as well.

Everything you posted may, in your mind be helpful, but we also need to see your stored procedure.

Mr J (11/24/2008)

---

Can someone please explain to me why this is not working ??

CREATE TABLE test AS

(SELECT A, MAX(B)

FROM ...

On a personal note, this forum thread allowed me to break 3000 forum posts!

Edit: And that does NOT count this post!

Paul Nicholson (11/24/2008)

---

Lynn,

I just realised that the server running the application is one that hasn't been upgraded to 2005 and is still running 2000 - I also noticed that there...

Paul Nicholson (11/24/2008)

---

Lynn,

Thanks very much for your offer of assistance, below is a sample (10 rows) CSV file from the major query providing the source data. Further down is...

To make things easier, provide me with sample data as it would come as the result of your major query, you know the one with all those left and right...

The thing is, what I am seeing is a very procedural process. When moving to SQL, you have to change your mind set to a set based approach. ...

Jeffrey Williams (11/24/2008)

-- CASE

SELECT CASE WHEN col1 < 50 THEN 0

WHEN col1 < 40 THEN...

Some sample data and expected results based on the sample data would also be quite welcome.

RBAR! You should be able to do this in a set based query. First thing to ask, WHAT are trying to accomplish, NOT HOW do you do it....

jacroberts (11/24/2008)

---

timothyawiseman (11/24/2008)

---

I agree with Jeff that performance should always be a concern. After all, you may eventually need...

Have you read the article about running totals that I have linked in my signature block below? If not, you might want to spend some time reading it and...

Could you explain in greater detail what it is you want to accomplish?