Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Tim F
Starting Member
35 Posts |
 Posted - 2005-04-22 : 11:32:20
|
I've got a script that is failing due to permissions somewhere in the system, it's to complex to go down that route to fix it. Is there any other way to case sensitivity?? You can see what I was doing!!!!  Many thanks, TIM  select p.person_id, p.surname, p.forename from sims.per_employee e inner join sims.sims_person p on p.person_id = e.person_id left outer join ( select count(p.surname + p.forename) as surnameandforename, p.surname, p.forename from sims.per_employee e inner join sims.sims_person p on p.person_id = e.person_id group by p.surname, p.forename having count(p.surname + p.forename) > 1 --order by surname ) x on x.surname = p.surname and ( LEFT(p.forename, 1) = LEFT(x.forename, 1) or x.forename is null ) where UPPER(p.surname) = p.Surname collate Latin1_General_CS_AS and (UPPER(p.forename) = p.forename collate Latin1_General_CS_AS or p.forename is null ) and x.surname is not null -- Where they are a duplicate |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2005-04-22 : 15:57:16
|
| What does a problem with permissions have to do with case sensitivity? Where is the error? What unexpected result are you getting? We need a lot more information to help.Tara |
 |
|
|
|
|
|
Alternative for collate (case sensitive stuff)???