this might help: http://www.mssqlcity.com/Articles/Undoc/UndocExtSP.htm

xp_regread

This extended stored procedure is used to read from the registry.

Syntax:

EXECUTE xp_regread [@rootkey=]'rootkey',

...

Hi guys

thanks for the info, since the exams don't contain R2 questions I don't think I'll bother buying the r2 version of the software just yet. I will however look...

Hi

Though I'm no expert my initial thought is, that they might not be any difference in the two selects when using an OR where, because SQL would have to check...

grats on the cert! well done.

I'm currently going throught a book to eventually take the exam. How long did it take you to study?

ColdCoffee,

Thanks for all the help I've spent this morning playing around with the code and it works great. I did have a go last night before joining the forum but...

Hi

Yes, I'm very new to the forum, so will certainly read the Etiquette artical and follow it. Thanks for the help, PIVOTS are really new to me so still trying...

Hi

Thanks for the links to the articals, I'll certainly look over them tomorrow, but I'm not sure pivot tables can be used for what I need as it requires an...