Search results for query: *

I'm using an exchange server actually SBS 2003 and a 3rd party POP3 connector to get external e-mail and route to exchange. All external e-mail routing works however users of the exchange server CANNOT send e-mail messages among themselves or internally, if they do they get a: “User doesn’t...

I have a union query which has perfect syntax and is a legal statement. SELECT ID, Name, Company, Fax1, Notes FROM dbo.right_fax_unified_phonebook WHERE (Fax1 IS NOT NULL) UNION SELECT ID, Name, Company, Fax2, Notes FROM dbo.right_fax_unified_phonebook1 WHERE...

I have a need to merge data columns in a table. I'm using rightfax and I need to merge data in a FAX column and in an E-MAIL column both columns are text columns. Here is an example from table tbl.Customers: INITIAL TABLE CONTENT: NAME FAX E-MAIL ----- ---------...

Happy Holidays everyone! I need some help! I have to chart off numerical data in a database. For the x-axis there are 3 different possible sets of data that can be &quot;pulled&quot; out of the database. Data Sets --------- 1. Numerical value <> 0 2. Numerical value = 0 3. <NULL> Data Set #1...

Here is my issue: In the details section I have a bunch of last names displayed, some lastnames have been displayed as all caps ucase() or all lowercase lcase() based on a certain if...then condition. An example result set in the details section looks like this: THOMAS THOMAS thomas THOMAS...

I'm reporting of a metadata database, this is a very unique database design (see US Patent - 5,267,155 this is the foundation of this database design). This is a user definable database. It's a 13year old design. The databases initial design function was to serve as a computer based...