Hello Kristen

Thanks, that is a good idea and is kind of what we have tried.

We have a test system set up which is the same as the live system and...

Hello Bill

Thanks for your response. It is interesting that not having clustered indexes helped in your system.

People do complain but have mostly got used to putting up with waiting an...

Hello Jeff

Thanks for explaining this as I did wonder where the rocket propelled pigs had come from!

I've just been in touch with another organisation that uses the same software and...

Hello Gail

Thanks a lot for your quick response.

Using the OUTPUT value has worked and allowed me to return the value I needed.

Thanks

Robin

I was going to say I'm sure that the software house will admit full responsibility for their shoddy work and give me a script to quickly create all the indexes...

Hello Kristen

Thanks for your response. I agree I do find it much harder trying to fix other people's code and code in 3rd party apps.

The database in question also doesn't...

Thanks I didn't think of looking at SQL Profiler as even if I can't do anything about it at least I can complain to them to maybe influence them to...

Hello all

Thanks for the replies.

The software in question was developed many years ago and whilst it is still supported and maintained it does look and feel very old fashioned with...

Thanks, I missed that part!

Hello All

I'm just wondering, is there anything wrong with doing it this way:

SELECT DISTINCT

P.CustomerID

FROM #Purchase P

LEFT JOIN (

SELECT

P.CustomerID

FROM Purchase P

WHERE

P.ProductCode = 'C'

) NP ON NP.CustomerID = P.CustomerID

WHERE

P.ProductCode IN (...

Hello all

Thanks for your replies. I never did get around to writing some sql for table creation as something else has been taking up all my time.

weitzera: Thanks for your...

Hello Lutz

Sorry I haven't managed to get time to do this yet but will try tomorrow.

Robin

Hello lmu92

It's not homework actually. I work as an Information Analyst in a college. I can see that it would make a good homework question though!

I did not post the...