Hi

Thanks for the reply.

I managed to get the following working:

update jobs

set comm = 0

from jobs join customer on jobs.cus_id=customer.cus_id

where customer.rate_group = '1'

and weekno = 200902

Thanks,

I'll try some of these suggestions.

Matt

Nice one.

Looks like I shall be researching the 'HAVING' function.

Thanks,

Matt

Hi,

This did the trick !

What would you call this technique, so I can read up on it ??

Thanks,

Matt

Hi,

Although I am still interested to why you get duplicate instances displayed, it wasn't the cause of my problem. The main cause of my now fixed problem was me being...

Found it, I had the Windows Authentication only mode rather than the Mixed mode.

Oh well, still interested if there is a simpler solution.

Vikas,

Thank you for your help, I haven't formulated a script like this before.

Espescially curious to know how I specifiy the backup of a database from a different machine.

Any...

Hi,

Database is no more than 2-3gb

Looking at just one user. Basically the function is recruitment service that has on-call facility. They need all the data such as worker details, next...

thanks, that helps out

bump

Andrew,

Thanks for all your help, managed a little work around by using: Like '%L%', but all good knowledge to be retained for later use !!

Matt

Hi Andrew,

Which bit do I put the RTRIM in ?

A bit new to SQL !!

Matt

Thanks, for your replies.

The first one worked as expected, however there is a problem in that the taxcode field seems to have spaces after the L. So you might have...

Thanks for your help guys. Worked nicely.

Matt