I would do something like this

WHERE cr.role = ('MAIN') and cr.contact_number not in(select contact_number from Contract_Roles where cr.role= "PREX")

AND cp.mail = 'Y' AND (org.status In ('BRAN','FULL'))

The subquery (select contact_number...

Okay makes sense, do your contacts have a unique indentifier?

WHERE cr.role In ('MAIN') AND cr.role != ('PREX') AND cp.mail = 'Y' AND (org.status In ('BRAN','FULL'))

should be

WHERE cr.role = ('MAIN') AND cp.mail = 'Y' AND (org.status In ('BRAN','FULL'))

You shouldn't...

How do you use Windows Authentication to secure specific reports?

A lot of servers will have xp_cmdshell turned off for security reasons.

There a lot of jobs out there for experienced BI developers and designers it is a really interesteing and growing area as a lot of companies are looking at getting...

in SSMS you can run

select @@servername

What are the rules for updating Type and Brand how do these relate to the LOC_ID ?

This situation looks like it could be handled better with a lookup table...

First Question: Have you used reporting services?

It sounds like you are doing something wrong having 500 clauses using IN.

can you put these into a lookup table and match on that? it would be...

No it doesn't sorry.

You could maybe try something with the Transactional Log and do a point in time restore of your data.

If a student is absent for five or more times, which date would you like the query to return?

I was just being curious, I like to find out why people are doing things in certain way in SQL queries.. This sounds like something that the Government would do...

Does this selection method have reasoning based up Statistical Theory?

What are the regulations/reasons for not selecting 30 random people from the 100 ?

I am curious why you need this information.

Are you preparing to write the monster SELECT statement and want to see what system can handle it?

Or are you simply doing a...