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 strongm 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: *

  1. ElTech

    Configuring Linux AMD PC NET network card in VMware GSX Server

    I just wanted to post this here as an FYI since it took me several hours to find out how to do it: Configuring Linux AMD PC NET network card in VMware GSX Server After installing Red Hat, the network card may not be detected by linux, here is how to install the nic...
  2. ElTech

    Configuring Linux AMD PC NET network card in VMware GSX Server

    <html> <head> <title>I just wanted to post this here as an FYI since it took me several hours to find out how to do it:</title> </head> <body lang=EN-US style='tab-interval:.5in'> <div class=Section1> <p class=MsoNormal><span style='font-size:11.0pt;font-family:Verdana'>I just wanted to...
  3. ElTech

    SQL Server memory leak?

    My production server (MSSQL 2000 Server with Service pack 4) is set to use Dinamically configured memory at 4MB to 1503MB max. After a few days, the process sqlservr.exe is using 1,609,560 K and growing. The host operating system is Windows 2000 with Service pack 4. The applications using the...
  4. ElTech

    Hard drive about to fail after Windows XP test?

    You may also Wanto to check you Windows Event Viewer (Right-click on my computer and select manage, expand the Event Viewer + sign and look for red error in the application and system log). It will tell you about error that you may be unaware of. Here are some of the utilities that I use to...
  5. ElTech

    QUERY to display all row in two tables

    How can I display all rows for vendorkey even if vendorkey is null on table vendors select vendor.name, vendor.key, vendor.id, item.number, item.name from dbo.vendor, dbo.item where vendor.key = item.vendorkey With the query above I only get data that exists on table vednor I want to get...
  6. ElTech

    Group sort - need sql expression

    I'm using 8.5. I also have version 10 but prefer to use 8.5 because is more compatible with other older software i'm using. Also, this is for group sorting.
  7. ElTech

    Group sort - need sql expression

    I want to sort by the following formula but need an sql expression. any help will be great if {@OriginalQty} = 0 then 0.00 else (Sum ({Items_Sold.Quantity}, {Items_Sold.ItemNumber})%{@OriginalQty}) The code for @OriginalQty is {Items_Sold.QtyOnHand}+(Sum ({Items_Sold.Quantity}...
  8. ElTech

    DateAdd function to add 15 minutes

    I have the same database. How would I display an hourly total instead of a 15 interval total?
  9. ElTech

    Command to delete 0 Kb files with php

    I'm looking for a command for Redhat 8 that deletes 0 Kb files with extension .php including files located inside sub-directories Thanks for your help in advance
  10. ElTech

    Nortel Sysmposium, NextiraOne Heatline and EMC CTI reader boards

    Any ideas how to make the EMC CTI reader boards work with NextiraOne Heatline server is appreciated
  11. ElTech

    Book recommendations for New Crystal Reports users

    Hi, do you have any book recommendations for New Crystal Reports users
  12. ElTech

    Selecting one record with relation to two tables

    Thanks SantaMufasa. I have one system table that contains the admin number. Once in a while we need to delete all users, except the admin. So the command will have to delete from users where userid <> system table admin_user_ID
  13. ElTech

    Selecting one record with relation to two tables

    How can I select one record with relation to two tables for example select * from system where user_id=admin_table id and the result should be the name of the user whos id in the admin_table = the user_id in the users table
  14. ElTech

    Current user query

    We made the usernames all equal 7 characters first 4 letters of first name and first 3 of last name Replacing last letter with numbers if duplicates will exist Examples: John Hill username=JohnHil If we hire another JohnHill then username=JohnHi2
  15. ElTech

    Current user query

    If I run SELECT right(user,7) I get the correct output User JohnHill The following is not working: select transaction from order where user=right('user',7) 0 results select transaction from order where user=JohnHill 10 results
  16. ElTech

    Current user query

    I have a query that requires that the current user's name = the username in the database when I query &quot;select user&quot; I get &quot;domain\username&quot; how can I tell my query that the username is the last 7 characters of the user result
  17. ElTech

    Why is my Linux Server slow?

    Why is my Linux Server slow? I have found that the following can cause a Linux server to slow down when connected or not connected to a Network. a-DNS unreachable or invalid: the /etc/resolv.conf file contains a DNS server not reachable by the Linux server or invalid DNS. To change the...
  18. ElTech

    Current Date Query Problem

    I'm running a query where the database has a date format of 2003-07-31 10:43:56.717 what command can I use to retrive records created 2 days ago For example select * from customers where createDate = 'currentdatetime' I tried that I got a couple of errors about the date format not being correct
  19. ElTech

    VPN and Remote Desktop

    I have not been able to fix this issue. I tried the following so far: removed and re-installed the Remote Desktop Client Upgraded my Router's Firmware
  20. ElTech

    Inactive Feature

    I already Tried the following F903 Inactive Feature Then F983 Inactive Feature .tried to call the pilot port directly and no answers

Part and Inventory Search

Back
Top