I am not sure if there is really a performance issue - but, truncating the table is (IMHO) a bit cleaner. I do know that truncating the table will...

Fernando (7/29/2008)

---

Thanks, I refresh test to have the most current data (difference is just from 11:30 AM to now)

The statistics were the first step to optimize the query. Indexes were...

What is the following parts of your query supposed to be checking?

WHERE @category = 'hardware'

AND @series = '1500'

AND @diameter = '5"'

...

I am guessing, but that query definitely looks like something that would come from running a Profiler trace. If you were running profiler at the same time - that...

Do you possibly have more data in live than in the test system? Are the statistics up to date on all tables involved in this query?

rconway (7/29/2008)

---

I am creating a Stored Procedure in SQL Server 2005 and I am getting this error message and I can't figure out why:

Msg 156, Level 15, State 1, Procedure...

Perry Whittle (7/28/2008)

---

alimcitp (7/28/2008)

---

Gilla Monster, I dont know why you are trying to change the subject of my post. Actually what I requested is that " IF SOME ONE CAN...

The reason you are getting this error is because you are not using a GROUP BY query, so you can't use HAVING with a SUM.

It is not clear what you...

You can use

SET DATEFORMAT dmy;

Or, you can use CONVERT in the select statement. Date formats are usually better controlled in the client.

Dates are not stored in a format - this is controlled when you query the database and can be set using DATEFORMAT. The other option is to use CONVERT...

Under Tools | Options | Designers there is a transaction time-out setting. It should be set to 30 seconds. You can try changing the timeout here and see...

Look up aggregate functions in BOL. What you are looking for is a simple aggregate query using SUM and GROUP BY.

Check out the system views sys.columns or information_schema.columns.

What is your connection string? There is a 'feature' for SQL Server 2005 call User Instances that you may be running into.

If you are using AttachDbFilename in your connection...

David Jackson (7/24/2008)

---

You know what it's like, you post a question and then while reflecting on your problem, you solve it having a smoke...

This works, but I still don't like...