Search results for query: *

I'm trying to design a report that will display sales by (3) separate date ranges. The ranges are not related. Range 1 could be a single day and range could could be a specified week or month, same goes for date range 3. Item # sales for range1 sales for range2 sales range3 I setup...

I'm trying to union join (2) tables that have the same columns, however, they're in unlike order. A work table and it's associated history table. I want to create a new table (View) that will hold all the records from both tables. In attempting, I've discovered that the tables have all the...

I need help with a script that will compare; TABLE A, fields LASTNAME, ADDRESS1,CITY,STATE,ZIP with TABLE B, fields LASTNAME, ADDRESS1,CITY,STATE,ZIP AND where a record from TABLE A does NOT exist in TABLE B, returns those records as the results. We purchased outside customer list and want to...

Windows 2000 AD - Using WSH Scripting I want to add some script code to our logon script where if the user is logging onto a specified server (destination computer name) that a specified sub routine in the logon script won't run. If logging onto computer A, then bypass the following routine so...

I want to write a query that will return the values where the column data in question is either [= "A" or begins with "S%"] and I'm having difficulty getting this work. Appreciate any tips and/or suggestions. Thanks, zaw

Windows 2000 ADUC I started an assignment to clean up old computer accounts and noticed that there were several accounts that had the following attributues; First, these accounts were live, physical systems in use. Single Forest, single domain, single subnet, DHCP I could not ping these...

I can restore mailboxes to their original location, but, the checkbox for REDIRECT is grayed out so I can't redirect a mail box restore to another mailbox. The HELP indicates that this can be done, so, I'm guessing I have a setup or configuration problem. Appreciate any tips or suggestions...

Environment; Windows 2003 Terminal Server Have four entries in the licensing window. One "Built-In" with Unlimited availability.?? Not sure what that means. One entry is titled "Temporary" with 0 total & available, but 1 Issued. the last 2 are "Open" and "by device". One entry is for 10...

I';m looking for Watchguard firebox v6.1 128 bit encryption. (WFS61s.exe) I have an email from 2002 where the above named file has been removed by our email security. I need to access an old Firebox II that has some settings I need to copy over to our new X700, but, the desktop that had the...

This issue pertains to one specific user. Somehow, th is user can no longer see their list of contacts when pathing out to a recipient address when sending a new email. You can view the contacts in the contact folder, however, when you composea new new email and go to use an address from that...

I need help with a script that will query a table with items (inventory items) and return the results where that item only has one record. Each item is assigned to a site when entered into our inventory system. Later an item can be assigned to various different sites (locations). Initailly...

Compaq proliant 1600 - 3200 array controller windows 2000 AD - Main DC of network server I have a raid 1+0 array with a failed drive. The server is operating normally and no users have complained about perfromance or any other issues related to this. I have a identical drive to swao out with...

In Enterprise manager when you click on a table I see "COPY" as an option. When I click on Copy, the screen flashes and nothing, that I can tell, happens. I'm looking for a way to copy an existing table and have the ability to rename it with all the data types/structure associated with the...

windows 2000 (sp4) iis 5.0 setup interanl CA, issues certificate for internal virtual directory (website). users can access this site using either http or https. setting up the SSL did not prevent use of http. there must be a setting that I missed to liits access to only requires secured...

windows 2000, iis 5.0 setup an internal CA. created certifcate for site(virtual directory). can still access site using url with http, along with now using https. how to limit access to only https? Thanks, zaw

Can someone assist me with a query that will return the records of Table A where those records are not in Table B Comparing to inventory tables, one the master, the other the pricing table. Items were accidently deleted from the master, so I need to remove the associated record from the...

I need help with a script to add data (update) table 1 from table 2 where field 1 in table 1 = field 1 in table 2. The records in table 2 already exist in table 1, I just want to add values from specified fields in table 2 to same specified fields in table 1. Appreciate any assistance, zaw

due to ageing, I need to decommission our server acting as our dc (windows 2000 ad) add replace it with a new server acting as the new DC. Is there a techdoc available that details the recommended steps for this process? I haven't had any success locating a document that is specific to this...

Is there a function that will convert the values in a character type field to a numeric value? I have a field that's char (21), however, the data in the field is actually sales numbers. I want to convert the values to numeric. ex: char 35.800000 to numeric 35.80 Thanks, zaw

Crystal v8.5 w/SQL Server 2000 / Windows 2000 Designing a report to show sales by brand by joining the customer master table to the sales history table by custid. The problem is that the join limits the results to only records where there is an actual sale, which I understand. If the...