Lynn Pettis (6/26/2008)

---

I'd need a little more specifics. The table DDL, smaple data (in the form of insert statements that can be cut, pasted, and executed to populate the...

I'm predominantly a nature photographer, so I like it as it gives me a chance to be geeky in a non office / house environment haha!

Nope, far from it, I still need to make a decision, and a proposal I guess :p

Yeah, it's clear that certain job titles convey certain 'signals' that's why I was initially not keen on DBA as when ever non tech people see the word 'admin' they...

Exactly, that's why I want to...

Jeff Moden (6/20/2008)

---

What are you? Skilled with a lot of intellectual curiosity and the propensity to be much more, I'd say.

I think you should pick whatever title you like....

I suppose that's the small company side of things coming out - I was hired for a non technical analyst position many moons ago, then it just kinda snowballed!

Seeeeeeeeeequellllllllllllll

For me

Yup, I am in to photography, as is my colleague - a developer 🙂

I've looked at rank and dense rank, I am not really sure about the no gaps thing - if a contact had a score of zero then would rank simply...

Thanks Mark, I looked it up and it works a treat 🙂

RANK() OVER

(PARTITION BY firm_ID ORDER BY ContactScore DESC) AS 'RANK'

Did the trick just right!

My query is something like this:

SELECT T.*, [Total Coms]+[GP Contact]+[Has Email] as Contact_Score FROM

(SELECT

c.contact_id,

c.contact_title,

c.contact_surname,

f.firm_name,

--Contact Scoring--

(SELECT count(distinct communication_ID) from tblcommunication cn where cn.contact_id = c.contact_id) [Total Coms],

(SELECT count(contact_id) from...

Thanks for the code, there isn't too many entries which are a problem so I think a manual review of them will sort it out.

As for preventing it... ill...

Vladan, I have realised that now - its simply the ASP file that 'renders' the '& # 256' type stuff in to characters, they are actually stored in sql in...

Vladan,

The information about the SQL collation is very interesting, Ill mention this to someone else and see what they make of it.

The input data is in asp, soon...