Thank you

Hi,

I have resolved the issue......I put a sub select statement in the WHERE section which I failed to mention...my bad!

Therefore, I needed to place COLLATE Latin1_General_CI_AS in the where clause:

WHERE...

Hi Sergiy,

I tried what you suggested above but I get an 'Expression type int is invalid for COLLATE clause'

My ID column is an int. If you are referring to OrderID...

Hi Prasad,

Your solution worked a treated.

Thank you very much for your help!

Cheers

Reet.

Cheers

Seems to have done the trick!

Hi,

I check my results and they seem fine but if there is another way then i would be very grateful to hear from you. The query that I am...

I've put a GROUP BY clause in it and it seems to have done the trick!

Hey Joe,

Thanks for your input too. I'm sure that code will come in handy at some point so thank you for taking the tiem to help me out.

Cheers

Reet

Thanks Ryan,

You're a star!

To be honest I never even thought about just using:

UPDATE tableA

SET

fieldA = isnull(@p1, fieldA),

...

Hi,

Thanks for the info Joe but i'm not sure whether your code can help me on this occassion. Sorry, it's my fault as Ryan said I should have included code...

Ryan,

You're a star! Thank you very much - worked a treat!

Cheers

Reet

Thanks guys for all your help. I ended up creating a DTS.

Cheers

Reet

Hi John and Jules,

I wanted to thank you both very much. I ran the index wizard and implemented the recommendations and performance has improved by 85%!!!!

Absolutely marvelllous!!!

Thank you!

Reet x

Cheers for all you help guys. I really appreciated it!

Hi Guys,

I have double checked and the only outer join that I need is the first one. The reason for this is that some of the values in OMS...