Recent content by TheRogueWolf

If you run 'gpresult' from a command prompt on one of the clients does it show the default domain policy applying to that machine?

I've been struggling with this for the last few days so I'm hoping someone here can help. I'm trying to install MS Office 2010 on user's machines using Group Policy. I have read all the MS literature and so far have the following: * A network install location (\\server\share\office2010) which...

My apologies, it is InstallOffice2010.bat that is not working via the GPO, not CacheOffice2010.bat.

Update: I have also tried changing CacheOffice2010.bat to use the network install point instead of the local cache; still no joy.

I've been struggling with this for the last few days so I'm hoping someone here can help. I'm trying to install MS Office 2010 on user's machines using Group Policy. I have read all the MS literature and so far have the following: * A network install location (\\server\share\office2010) which...

That's done the trick, thanks again markros :)

Thanks again for your invaluable help. I'll try that in the morning and let you know the result...

Thanks Markros, sorry for the delay in my reply. It's unfortunate that although I thought that SupplierNum uniquely identified the supplier, this is not the case. The same SupplierNum is used by three different companies (I should mention that these companies are our internal...

Back again I'm afraid. I seem to have a bit of a problem with the code Markros kindly provided. While at first glance it appears to be working correctly, a bit more investigation shows that:WHERE supplier.company = 'SF04' doesn't seem to be working as I expected. Specifically, there is a...

Thanks markros, that did the trick perfectly. Thanks again Jamfool, unfortunately I couldn't get your version to work but that's no doubt due to my beginner's SQL skills.

Would you be able to give me an example of how to do this please? This is a bit beyond my current SQL abilities :-)

Sorry about this, I have one more question. I now need to select only orders which have been approved. This is indicated by a field in another table (orderheader.approvalstatus) which could be linked to the orderdetail table using the .ordernum field. Could you give me a bit more help on how...

My apologies. I've just discovered that there are duplicate suppliernum entries in the suppliers table because different departments use the same suppliernum but for different suppliers (I hasten to add that I didn't design these tables) :-) I've added a WHERE clause to limit the results to a...

Thanks Jamfool, that's a helpful resource. I've written the following code: SELECT supplier.suppliernum, supplier.supplierid AS 'ID', supplier.name AS 'Name', sum (orderdetail.orderqty * orderdetail.unitcost) AS Total FROM supplier LEFT JOIN orderdetail ON supplier.suppliernum =...

Hi, I'm new to SQL queries but I think I've got the hang of the basics. I have a problem which I'm not sure how to proceed with, however, and I'm hoping someone can help. I have two tables: Supplier - suppliernum - name OrderDetail - suppliernum - orderqty - unitcost My aim is to get a...