Search results for query: *

I am having a problem with the Outlook Settings profile working consistently on a Mac Outlook 2001 client connecting to an Exchange server. I can setup an account in the Outlook Settings app using IP address of the exchange server and the mailbox ID, select Test and the account works fine. I...

God blessya, I couldn't get better advice if I paid. Last item I have is a defined foreign key of cono, prodid. So close!

After looking, cono is an integer. How do I format?

My version of that logic did not work, I failed to mention that. I input your suggestions and it shows as being syntactically correct. I will test and reply momentarily.

Formatting fell apart, but you get the idea. Primary key is cono, prodid, whseid and the sql is as follows: UPDATE product_warehouse SET cono = a.cono, prodid = a.prodid, whseid = a.whseid, addoncost = a.addoncost, arptype = a.arptype, averagecost =...

Possibly, Do I leave the IF NOT EXIST in?

I am new to programming SQL (fixing somebody elses oversights). I am attempting to take data from a source table (updated daily) in insert/update into a destination table which already has 100-200K records. Most of the records are updates, but some will be new records. The logic I used is...

Have you tried to use the Show Values criteria in the Query?

I have been using Brio Intell for 3 years now. I have developed quite well in Query, Results and Pivots; and would now like to get strong in EIS. I am finding this to be rather difficult compared to the other sections, so I purchased the Brio Reference Manuals (following examples explicitly to...