Im loving these tactics. its almost manipulation of people, getting them to give the answer you want on their own!!! Brilliant!

Thanks guys. il look into that now! kind regards.

thanks for the reply. i am aware of log backups. the reason i am asking the question is because i want to have a strong case when i go to...

thanks guys. exactly the information i needed.

if i write a cube for a business group in my company, what front end can they use to view the data ( besides excel)? from what i see there...

perfect!! thanks a mil for the help guys.

I have learned lots from this exercise and the code you provided. its much appriciated.

Defo something im storing for reference at a later...

sorry, forgot to say, I was wondering if its possible with joins alone, rather than using a exists? If a contains is necessary, then so be it

not exactly.

The query must return orderIDs of orders that contain both products in the subset and not in teh subset.

Any orders that ONLY contain orders in the subset...

sure. Below is a simplified version of the data.

There is an order table. an order table can have many orderLines.

There is a product table containing all orderable products.

there is a...

I disagree about them needing to be more difficult than they currently are. I know the sql server 2000 exams were a joke. ive heard this from the mouths of...

Im afraid IMO you need to try to use SQL server as much as possible. the exam is tailored that way. The last 15 question on the exam are practical...

An example of where its used is here:

http://www.4guysfromrolla.com/webtech/071906-1.shtml

its used about half way down in a grey section of code. why does the article author use that here?

Sorry, I should have mentioned that it was in relation to the DMV's. I couldnt find any description of what an Index group was, but as you say, thats because...

Cant believe I never thought of trying that. Thanks a mil, that worked a treat!

as the tables are huge, and i cant go creating indexes on them as they are in a production envrionment, i just created temp tables and done a join on...