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...

Rahul, I have the same question. Has anyone responded to your post on how to create a report that utilizes (2) datbases running on the same server? Specifically, (2) identical SQL views, each residing in a different database. Then "union", if that's the correct concept, the two views in...

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...

zaw: again; BacupExec v8.6 for Windows 2000 Under the REDIRECTION tab, all options under "Redirect Exchange sets" are greyed out. Thanks, zaw

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...

now I looking at this from a different angle. what would be the proper syntax to update "tablename" with all the data from "table_copy_name". Both tables have exact structures, but "table_copy_name" has more recent data then "tablename". Sorry for any confusion. The responses are showing a...

That sounds good. I'm looking for simply the data structure. No data, or any triggers, indexes, etc. . I'm not interested in as well. I'll give this a try. Thanks, zaw

That's where I get stuck. After I would export it, I want to import back into an exact copy of the original table as far as data structure. The table in question has approximately 80 columns, so I was hoping for an automated method for creating this "copy" table and avoid all that manual entry.

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