Hi

The 'easy' answer is that it really depends on what you're going to feel most comfortable with - after all, you'll no doubt end up supporting the application when it's...

Hi

One more thing to add/think about is that I'm fairly sure SBS limits you to a max of 50 users which it appears you're already very close to so you...

Hi

Not sure whether it's a typo or intentional but why are you selecting the top 100 percent - surely that would just equate to everything (and will using a SELECT...

Ahh - now I understand, thanks for clarifying (and answering the original post).

Martin

Hi

Thanks for that - bit confused about the performance side though - when you say that performance will suffer when using a function that selects from a table, isn't that...

Hi

Just a question (another!) - if I create the queries as inline table functions is that going to have a potential hit on performance as, from what I've read, UDF...

Hi

Thanks for the reply Remi - again, it's appreciated.  So would you suggest having two profile tables, one for experience and one for qualifications?  Just wasn't sure whether to do...

Hi

Just wanted to say thanks to everyone that has posted a solution/suggestion on this - I appreciate it. Apologies for not doing this earlier but my mother has been...

Hi Jo,

Thanks for that - must say that at least I understand yor version but unfortunately the number of 'must have' and 'nice to have' qualifications is going to...

Sorry (again!) - you beat me to it, was just about to post that it'd been answered elsewhere.  Like I said in the posting, wasn't really sure where to post...

Whoah hos! I take it back about kicking myself as I'd never had come up with anything like that (or even knew where to begin with something like that!!)

A BIG...