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 Chriss Miller 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: ElTech
  • Content: Threads
  • Order by date
  1. 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...
  2. 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...
  3. 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...
  4. 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}...
  5. 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
  6. 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
  7. ElTech

    Book recommendations for New Crystal Reports users

    Hi, do you have any book recommendations for New Crystal Reports users
  8. 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
  9. 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
  10. 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
  11. ElTech

    Inactive Feature

    Inactive Feature when tryting to configure voice mail Inactive Feature 9*1 or 983 etc M8x24 ds Software version NT5B24DH-93 Voicemail hardware 10/19/02 NNTM84566 NTAB2455 Rel 01A 2 channels 4/04 Flash card A0791005 1/18/02 Rel 4 0004 VM 2.0 7/03
  12. ElTech

    How to add an Analog lineDN to a Meridian Modular / Compact DR system

    How do you add an Analog line/DN to a Meridian Modular / Compact DR system?
  13. ElTech

    How to install Norstar v-mail system

    How do I connect a Flash / Norstar Voice Mail System to a Meridian Modular / Compact DR5. I already have the Meridian system working, all lines programmed and ready. I only need to know what special cable, etc. I need.

Part and Inventory Search

Back
Top