Cheers. I initially thought about that but I thought it was too simple lol. Many thanks it seems to have worked. Sometimes the best solutions are the easiest ones!!

Basically I am trying to amend a work mates sql script. Currently his code is as follows.

SELECT OP.Attendance_ID, dbo.udf_providerCode(OP.PAS_data_source) AS providerCode, dbo.PBC_Providers.providerName,

OP.NHS_Number,

OP.Postcode_of_Usual_Address,...

In both cases they would be classed as 1 day. so a value of 1 should be returned. The time isn't involved in the calculation.

Cheers that works.

cheers. That makes sense!!

could you basically explain the logic behind using NOT ISNULL to acheive results.

thanks. It works now.

I tried this script and it produces the dupes for other codes. I would like it to produce only the dupe records having POD = 'OPFA'

Just one more thing. I was just playing around with script similar to yours for finding mismatched names. when I use the GROUP BY clause I get 1491 records. When...

Thank you very much. I think i should be able to work it from there. That is makes a lot of sense.

It is just a once of thing that i was given to do. I imported the data from an excel file. The reference table contains the correct data i.e...

What is the best method for identifying those duplicate records when i add extra colums as that iniformaiton would be quite importnat for my manager.

How do I enebale server and workstation services and I am not sure what I am supposed to do in the msdb database. Could you expand a little more....

it says i do not have access to this network resource and that I should contact my network administrator. The computer used to be an old pc from work which...

Just done that and still no luck