I've created a better script to provide test data.

IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[SizeScaleDetail]') AND type in (N'U'))

DROP TABLE [dbo].[SizeScaleDetail]

GO

IF EXISTS (SELECT * FROM...

Michelle, thanks for your reply. However I can't do it this way, I need this to be linked to the SizeScale table because we're using different scales for different...

Thanks a lot Chris. That works perfectly on my test script, I'm gonna have to try it on the real database but it should work just the same.

I think...

Some of our customers sends us orders regularly, sometimes as many as 2 or 3 within a week. They...

There's probably a better way of doing this but I'm new to SQL and I'm learning "on the spot" while making my old applications work with a new system my...

Jeff Moden (10/15/2008)

---

Would you mind telling us what your mistake was? ...

Nevermind.....I found my mistake....after 3 hours. I tried to delete the post but it's not working !

I tried both methods and they both worked fine.

Thanks a lot, you two just saved me a lot of time in the next few weeks spent doing...........nothing but wait for...

Michael Valentine Jones (8/15/2008)

---

The only solution I could suggest that would really solve the problem is to have them fix the application. Of course that is not going to...

Thanks guys. I'm a beginner at SQL and I still have a lot to learn. For instance I didn't know that it's possible to populaire multiple variables in...

Jack,

I modified your code to run it with my tables. The results are very telling......and scary :unsure:

The "IN Claude" takes an average of 575ms to run. There's one...

Grant,

Here's a short description of what I do. The .NET app that I'm writing will run in Windows CE Device. This is a typical physical inventory count. ...

Wow, lots of answer for me today......and lots to reply to ;), this is good, I'm learning new stuff :D.

Let's start with Michael: About disk fragmentation, the disks where...

To say the truth, splitting up files on the same disk didn't make much sense to me but since I'm no hardware specialist I thought maybe the IO's from each...

Thanks everyone for your answers, they're all very helpful. I'd like to comment on Michael's points.

Michael Earl (8/7/2008)

---

I understand being stuck with a bad application, but since you are...