Search results for query: *

r937, Thank you, that helps tremendously. Pete

Hello, Please can you help? I've tied myself up in knots recently trying to understand joins (specifically to more than 2 tables) and I think I need some clarification before I can go any further. I've read in so many places over the web that a "join is a relationship between two and only two...

Hi Mark, Thank you for your reply, I will download the link tomorrow at work. It certainly looks the business! Thanks again, Pete

Dear All, Please can you help? I found a thread posted a couple of years ago from a guy who was experiencing exactly the same problem as me but unfortunately there was no reply. Basically I want to write a couple of VBSCRIPTS (i'm OK at doing that) but when I run them from the script IDE, no...

Apologies, I've just remembered a question that I meant to ask first time round to do with errors. Lets say that the database is updated from a stored procedured called from the Excel App, in the event of an error if the sp only contains UPDATE presumably nothing gets committed? But what about...

Thank you for your help. I think you are both more-or-less saying that there is no *definative* best way to do it but probably an update rather than a delete/insert would be more efficient. Thanks again Pete

Dear All, Please can you help/advise on the best way forward? Assume I have a single table, containing 22 fields - 1 * varchar(10) for Productno (key field), 1 * varchar(10) for location (Unique for product, but potentially duplicated across products) and 20 * numeric(18,2) containing...