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!

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

Recent content by ElTech

  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

Part and Inventory Search

Back
Top