Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: awise
  • Order by date
  1. awise

    Sales for Mutilpe Date Ranges in single report

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

    How to add tables from different databases on same Server

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

    Syntax for a Union where tables are slightly different

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

    Comparing multiple fields between (2) Tables

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

    Windows shell scripting

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

    Syntax to select mutilpe values form column

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

    Ping Failure, but resolves name to IP

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

    BE v8.6 - Can Not redirect Mailbox Restore

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

    BE v8.6 - Can Not redirect Mailbox Restore

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

    Terminal Server Licensing

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

    Looking for old software for Firebox II

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

    Outllok 2000 - Missing Contacts

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

    Script to identify records

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

    smart array controller 3200 failed drive

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

    how to copy a table

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

    how to copy a table

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

    how to copy a table

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

    how to copy a table

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

    internal CA allows access via http or https

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

    Setup CA, issued Cert but can still access site w/o SSL

    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

Part and Inventory Search

Back
Top