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!

Recent content by Garling

  1. Garling

    Changing some number in a SQL DB

    The data type is 'char'.
  2. Garling

    Changing some number in a SQL DB

    I have some phone numbers in a SQL DB that has the incorrect area code, the number format is 3339998888 where '333' is the area code. I need to change the first 3 digits of the number to '228', how can I do this using a SQL query? Thanks
  3. Garling

    Swap fields in a SQL DB

    This is what I was given that worked, if any ever needs something like this again. CREATE TABLE #InventoryUOM (Company char(1), StoreID numeric(5), itemnum numeric(9), UnitofMeasure char(20), Item_Price numeric(9,2)) INSERT INTO #InventoryUOM SELECT InventoryUOM.Company...
  4. Garling

    Swap fields in a SQL DB

    I have tried this: update inventoryUOM set item_price = inventoryUOM_Test.Item_price from inventoryUOM join inventoryUOM_Test on itemnum = inventoryUOM_Test.itemnum where UnitOfMeasure = 'box' and inventoryUOM_Test.UnitOfMeasure = 'each' and Item_price<>Item_price But I am getting these...
  5. Garling

    Swap fields in a SQL DB

    I have a SQL DB that has a table named: InventoryUOM With the following data. Num UOM Conv1 Conv2 Price Cost 1 Box 1 1 0.08 2.19 1 Each 100 1 4.87 2.19 What I need to do is have the box price swap with the each price. I am trying to get a query to run this. Any...
  6. Garling

    Installer package

    I am looking for an install package creator that will package up my software will a few extra exe's that need to be installed as well. Also need to to create a System DSN connection to a SQL server with the correct DB user name and database name. Does anyone know of anything like this? I am...
  7. Garling

    Shared calander in Exchange 2003

    I need to create a shared calander that a dept has access to , can this be done?
  8. Garling

    INcreasing member size of a Distro List in Exchange 2003

    I am using Exchange 2003 and outlook 2003, I need to create a distro list with 500 people, when I try it tells me that the dist list has reached the max size for your network server, how do I increase this size. Thank you
  9. Garling

    Modem Question

    I haved Googled it with no success.
  10. Garling

    Modem Question

    I have an external modem. FCC is H8NTAI-20977-MM-E, I cannot find any info except that it is made by Askey Computer. Does anyone know anything about this modem, speed, etc.
  11. Garling

    Motherboard boot problem

    I am seeing the fan on and turning and other devices come on ie..CD-ROM, HD etc, when they are connected.
  12. Garling

    Motherboard boot problem

    It will not POST Will not POTS prior to mounting to MB Fan is mounted correct All plugs have been checked CMOS have been cleared and recleared All devices have been removed, MB has on-board video, also tried other video cards. Would it be a bad PSU even if it works with prior MB and CPU...
  13. Garling

    Motherboard boot problem

    Done this aready, same prob.
  14. Garling

    Motherboard boot problem

    I am upgrading a clients computer with a PC Chips MB-825G motherboard and an AMD Sempron 2400+ CPU,512 PC 2700 power supply is 250 Watt. I can't get the board to boot. I have replaced the MB, CPU, and memory, still no boot. I get power but no signal to video. I am at a lost, could the power...
See more

Part and Inventory Search

Back
Top