Pretty close split between 15 and 16 for answers.

Not knowing anything more about the table, it looks like this query as written in the original post would benefit from a filtered covering index in SQL Server 2008.

Guessing from a previous post that this is SQL Server 2000, correct?

David Webb-200187 (7/17/2012)

---

My concern would be that if the non-clustered indexes were rebuilt, then the clustered index was rebuilt, the non-clustered indexes might get re-fragmnted based on the movement of...

Evil Kraig F (7/17/2012)

---

GilaMonster (7/17/2012)

---

I don't know. There have been some seriously...

Read this: http://www.sqlservercentral.com/articles/T-SQL/67898/

Since you are using SQL Server 2008, stay away from using @@rowcount to control your batches.

Cool, someone that actually knows that! You'd be amazed at those who don't.

Really???

gerard-593414 (7/17/2012)

---

But the issue I have is that I dont think an if will suffice to determine if the account already exists.

If two users run the code:

If exists(selectAcnum...

Here is one way. study it and be sure to ask questions where you don't understand what is happening.

Select distinct

a.artid,

a.catid,

a.Title,

...

Using a CTE, I think this is a little cleaner.

WITH BaseData AS (

SELECT

id,

nm,

SUM(AMT*1000) AS value

FROM

...

Sounds like two different language settings on the servers (OS).

That is not equal, != is equivalent to <>.

Koen Verbeeck (7/17/2012)

---

Lynn Pettis (7/17/2012)

---

rodjkidd (7/17/2012)

---

Lynn you beat me to it! They will just have to hire someone new to fill the B.A. position.

Grant, I did think about you and...

If I remember correctly there is a part of Indiana that also does not recognize DST. So, depending on Daylight Savings Time or Standard Time, they are eith in...